Application Express :: Process Inserting Multiple Row

Feb 22, 2013

I have a process on my page which inserting some tables. one table may have more than one row. say

id1, id2, attr1, desc
1 1001, 1, abc
2, 1001, 4, xyz
3, 1001, 5, hhh

so on. id2 is a fk key in this table. for same id2 it may have more than one row. I have process and following is part of it but getting error that is PLS-00224: object 'P30_QUES' must be of type function or array to be used this way .

declare
v_count number;
v_code number;

begin

select count(*) into vv_count from table1; -- it may have 7 or 8 questions

FOR i IN 1 .. v_count LOOP

select code into v_code from table1 where code = :p30_ques(i);

if :p30_ques(i) is not null then
INSERT INTO table2 (id1, id2, attr1, desc)
values (null,fk_value, v_code,nvl(:p30_ques(i),null));
end if;
commit;
end loop;
end;

View 4 Replies


ADVERTISEMENT

Application Express :: Obtaining Custom HTTP GET / POST Parameters Of Variable Length In Application Process

Sep 5, 2013

I'm trying to connect a javascript UI control within my page to an APEX Application Process. The control calls the application process via AJAX and appends a variable number of GET / POST parameters to its URL.What is the best way to obtain these parameters from within the PLSQL procedure of the process? Or is there a better way to connect my javascript AJAX control to the Database behind my APEX app?

View 4 Replies View Related

Application Express :: Change To Application Process Not Recognized?

Sep 13, 2013

I'm trying to make changes to a PL/SQL procedure in an application process and no matter what I do in the PL/SQL text (even removing semi-colons and messing up syntax) no changes register when I call the procedure from a page process. I've also tried creating a new application process with a similar procedure of a different name, and no page processes will allow me to call the procedure, saying that it needs to be declared. APEX 4.1.1

View 1 Replies View Related

Application Express :: Application Process Execution?

Jul 26, 2013

Application process (with htp.p in it) does not execute when onSubmit page process returns error (and shows it in notification bar).

How can I make process to execute? Or it is a bug? You can see example in test application Report 1Just press SUBMIT button and see difference near phrase "application process is here" at the top.

View 13 Replies View Related

Application Express :: Call A Process On Logout URL In 4.2?

Jan 3, 2013

I m using apex4.2 with wls10.3 and database 11g

I m trying to call a process on log out URLIn apex4.1 in authentication scheme we have logout url were we change the page were we need to redirect on logout click

But In apex4.2 under authentication scheme Post-Logout URL

I have given url here like this apex_authentication. logoutp_session _id=&SESSION. &p_app_id=&APP_ID.:117 on this page i have the two process but i m getting error System Unavailable.

View 2 Replies View Related

Application Express :: Inserting Into Two Tables From Two Regions In A Page

Aug 2, 2012

I am using apex 4.0.2.00.07. I have a page with two regions. The first region has only one row and I have no problems accessing it and inserting those values into the table this is what I used to access one column from that one row APEX_APPLICATION.G_F03(1)

The second region is an interactive report, to which I have managed to add a checkbox and a textbox.

1)So if a checkbox has been checked off the row should be inserted
2) if the textbox has been entered it should replaceone of the values.

My question is how to access the second region? I started a loop based on the rows in the collection but that is as far as I got.

FOR idx IN 1..l_collectionTable_name
loop
end loop

View 0 Replies View Related

Application Express :: Button Process With DBMS_SCHEDULER.run_job

Jul 17, 2012

I need to execute the DBMS_SCHEDULER.run_job on click of a button .I tried creating a process (On submit) with DBMS_SCHEDULER.run_job('JOBNAME')

when i tried executing directly in db there is no problem, but when i create the process in apex i am running into the following error

ORA-06550: line 2, column 19: PLS-00222: no function with name 'RUN_JOB' exists in this scope ORA-06550: line 2, column 1: PL/SQL: Statement ignored.

View 2 Replies View Related

Application Express :: How To Add Update Process To Printing A Report

Jun 29, 2012

I followed the directions to print a report using this documentation [URL]....where I setup a report query and a report layout and then add the url to a button that when clicked opens up the report in my chosen format. This all work very nicely. However, I need to update the table behind each record that gets printed and I cannot figure out how to couple the print request and an update process in APEX.

View 5 Replies View Related

Application Express :: How To Print Jasper Report From On-Demand Process

Aug 7, 2013

i have a report with a parameter that i would like to print out  from an On demand Process.When there is an Ajax Call Return. i want the report to show before printing.Here is an example of the code used  
 
DECLARE
l_customerid varchar2(200);
BEGIN 
l_customerid:= wwv_flow.g_x01;
select product_id

[Code]....

View 4 Replies View Related

Application Express :: Stop Submission Of Process On Refresh Page

Jun 25, 2013

I used to have a button, that called an after submit page process and everything ran fine.The page had loads of buttons, so I got rid of the buttons and created a list instead.I have an entry in a list. Target Type: Page, Page 1, Request is set to RUN_PLAN.This calls a before header page process with a condition of Request = Exp1 and Exp1 is set to RUN_PLAN. When the user clicks the list item, the process is run. This works fine.I also have a report on this page.As the process runs, it is updating a table.The user needs to watch this process running (via the report), so they need to keep refreshing the page.The problem is, that when they refresh the page via the browser refresh button the process is called again. How can I stop the process from running, every time the user refreshes the page. 

View 6 Replies View Related

Application Express :: How To Individually Process Each Row Of Tabular Form On Page

Nov 19, 2012

I have to create a tabular form, in which I have each row having an address information in it. I need to individually geocode each of these addresses and process it from the page (I have a web service to do the geocoding) .

How can I process each row of a tabular form individually from a page?

View 6 Replies View Related

Application Express :: Unable To Delete Multi Row Update Process?

Dec 8, 2012

I have created a simple page with a tabular form built on a view. The view is on top of a collection that is created when the page is ran. I added a tabular form column validation. I then was going to add a pl/sql process to handle the updates into the db, but before I did that I wanted to delete the ApplyMRU that was created when I first created the tabular form because it does not make sense on my view. When I went to delete the MRU it gave me an error saying "Multi Row Update processes can't be deleted as long as there are validations defined for the tabular form".

I have searched for an answer on this, but so far I have not found much. I am hoping it is something simple that I am missing. I even tried deleting the MRU first and then add the validation, but then it gave me another error about "Tabular form validations require multi-row update processes" I know this was possible in 4.1, but now I am trying it on 4.2

View 2 Replies View Related

Application Express :: JavaScript Assign Value Is Not Visible To Page Process

Aug 21, 2012

I have a page (16) and a tabular form when the user select the check box I update the zero page item

$x('P0_REPORT_REFNO').value=l_value;

this works fine till this point now i have a button will calls page 8 and pass the parameter to page 8 P0_REPORT_REFNO is displaying the selected value but passing null to page 8.I am running the application on apex.oracle.com

View 3 Replies View Related

Application Express :: Create Collection In A Process To Fire On Page Load

Dec 31, 2012

My collection is not working as expected, what could be the issue here. This is what i did,

1. I created a collection in a process to fire on page load

if apex_collection.collection_exists(p_collection_name=>'MMMM') then
apex_collection.delete_collection(p_collection_name=>'MMMM');
end if;
APEX_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION(p_collection_name => 'MMMM');

2. On my page i have a text field P1_text1 when i enter value into text field like ="sample data" i want this data loaded into my collection, so i created a button and added a process(on submit - before computations...) so it should insert into the collection when i click the button but no data is loaded, process:

APEX_COLLECTION.ADD_MEMBER(
p_collection_name => 'MMMM',
p_c001 => :P1_TEXT1,
p_c002 => 'TESTDATA' );

3. when i run the below query it shows "no data found" ,

SELECT c001,c002
FROM APEX_COLLECTIONS
WHERE collection_name = 'MMMM';

View 4 Replies View Related

Application Express :: When Email Sending Process Activated Pages Just Hang?

Aug 5, 2012

I have a system that has issues with sending some emails.

When the email sending process is activated the pages just hang.

Are there any logs or anything like that anywhere that i could look at to try and make sense of it.

View 1 Replies View Related

Application Express :: Include Data Files As Part Of Export Process?

Jan 14, 2013

if it is possible to include 'data' files as part of the Application Export process. Up till now I've only been able to include supporting object files which will recreate a table structure but not the data records - I've been creating the latter outside of APEX.

View 2 Replies View Related

Application Express :: Multiple Application Setup Using Session Sharing Within Workspace

Jan 24, 2013

I have multiple application set-up using session sharing within the workspace.Technically all works fine, however it does not play nice with user behaviour.

Example:
Users logs into APP_ID:100. Since he isn't authenticated yet, he provides user/pass and the APP_SESSION is authenticated.
Now if the user switches using to another application (using a link provided in application 100) he gets redirect to APP_ID:101:APP_SESSION all is fine.

The session is already authenticated, the application shares the session and the user gains access to app 101 without having to authenticate again. All's fine!

However users don't behave they way. Instead of using an easy link in the application. They will use their own bookmark or type in the url for app 101 manually. That way the next application is either called with f?p=101:1:[SOME OLD SESSIONID FROM BOOMARK] or f?p=101 (with no further page or session info) In both cases instead of using the already authenticated session apex spawns a new session, which of course isn't authenticated yet thus forcing the user to authenticate and come complaining they have to login again.

Similar behaviour problems exists when the user opens a browser and tries to open both applications in each in a tab next to each other.Both tabs fetch there own initial session id and start writing it to the same cookie each in turn invalidating the other tab's session.These can lead to some fanatic ping pong actions. Thus it's impossible to open 2 applications sharing session in the same browser.

Is there any remedy for these situations?Can apex be as smart as for instance first trying to resume the session stored in the cookie and only if that session is invalid, start a new session?

View 2 Replies View Related

Application Express :: Translate Application Into Multiple Language

Dec 20, 2012

I want to translate my application into multiple language,I did this by using translate application option available in shared component.This is working fine for me but ,the messages which is inside PL/SQL procedures are not getting converted.how can I translate those messages.

View 2 Replies View Related

Application Express :: (X) Process Taking 60% CPU In Two Session (30% Each Session)

Oct 23, 2012

We are using Apex 4.0/Oracle 10gR2/ Hp-Ux, We noticed that there is a process Running in Two Sessions that seems running since 3 Hours using 60% CPU,** 30% given below sql it executes in two Sessions!

declare function x return boolean is begin -- if instr(upper(:F4000_P4651_PLUG_SOURCE),'ORDER BY')>0 then
declare
l_position number := 0;
begin
loop
l_position := instr(upper(:F4000_P4651_PLUG_SOURCE),'ORDER BY ',l_position + 1) ;
exit when instr(upper(:F4000_P4651_PLUG_SOURCE),'ORDER BY ',l_position + 1) = 0 ;

[code]....

View 4 Replies View Related

Application Express :: Fetch Multiple Value Using Ajax

Aug 17, 2012

i am using apex4.1 and i am trying to fetch multiple value using Ajax code.i am using the following link

[URL]....

NOthis is based on select list . when i choose particular value in select list corresponding values are displayed in items.

my select list is too long. so i replace select list with pop lov of values item then this code do not work. what changes i have to do so that this code work.

View 0 Replies View Related

Application Express :: Authenticating With Multiple Domains

Sep 11, 2013

We are using APEX 4.1.1 with an LDAP authentication scheme. We now have a requirement to authenticate users from two different domains.

View 1 Replies View Related

Application Express :: How To Create Multiple PDF Files

Jan 12, 2013

I have two tables, one with the customer address and another one with a note. May I know how to create a separate PDF file (for each customer) that should start with the customer name/address (from customer table) and followed by a note (from the note table)

View 35 Replies View Related

Application Express :: Chart With Multiple Y-axis?

Mar 28, 2013

I am using the build-in flash Apex chart which I understand to be a subset of the Anychart.

I have the following problem, I have two series, which I am displaying in a 3D Bar Chart on a horizontal view with two Y-Axis. This works well, the problem is that each Y -Axis has a different scale. I am not setting the min or max value range for either of the y-axis as I do not know what this value range may be at the time of rendering the chart to the application user.

So as it turns out, the left y-axis has a value range from zero to 100 and the right y-axis has a value range from zero to 50 and the application users are finding this difficult and confusing as they are only looking at the bars represented in the chart and assuming that as the two bars, i.e. one form each series look similar in size, they have the same value and this can not be further from the true, as one y-axis is showing a value range twice as big as the other y-axis.

So my question is how do you customise the chart so that the value range on both y-axis is the same. i.e., the largest of the two?

View 7 Replies View Related

Application Express :: Oracle Apex 5 SOD - Multiple Regions

May 24, 2013

In Oracle Apex 5 SOD it says it will have the following feature:

"New Multi-Row Edit Region Type – Define a new region type with a modern UI for updating multiple rows of data and allow multiple regions on one page"

[URL].......

If so, how likely it will allow dynamic query (PL/SQL) in addition to simple query? Also, how likely it will include advanced features like frozen columns with group headers, subgrid, etc.? It will be nice if the grid will adjust itself based on the width of the screen.

View 2 Replies View Related

Application Express :: Retrieve All Data From One Multiple Checkbox To Another?

Jul 11, 2012

How do you retrieve all data from one multiple checkbox to another? The method I'm using returns one choice even though multiple have been chosen.

View 2 Replies View Related

Application Express :: Multiple Overlapping Series In Charts

Oct 11, 2012

whether the overlapping Multiple series charts are possible in Oracle APEX or not .

I am trying to create two graphs for two data sets , one as marker and another as line , but its giving me issues such as

1) X axis is taking all the points of the first series suppose(
1,5,10,180) itsplotting these first . and its then starting labeling
the x-axis for another one which has values like
(20,50,100,1000,15000)

so my X-axis is now ---> 1,5,10,180, 20,50,100,10000,150000

In case i make my marker chart series as the 2nd sequence , then its drawing all the markers on the right side of the chart .

[URL].........

Workspace:- NR_WORKSPACE
Username:-user1
password:- H123$

whether this thing is achievable in oracle apex or not , is there any work around ?

View 0 Replies View Related

Application Express :: Creating Tree With Multiple Tables?

Jun 20, 2012

I want to do a tree view based on the following tables in APEX:

create table plattform (
id number,
name varchar2(200))
create table environment (
id number,
plattform_id number,
name varchar2(200))

[code].....

View 4 Replies View Related

Application Express :: Report With Multiple Values For A Single Parameter

Oct 4, 2012

I have a user requirement where they want to be able to select multiple values for a single parameter that will act as a filter for a report. The possible values for a parameter can come from almost any master data Oracle eBusiness table. I don't want to just present the user with a LOV where they search down a list selecting what they want. That wouldn't be very practical for selecting part numbers from 1000's of rows. I also want the user to easily see what values they have selected. I thought about providing a button that would navigate to a multi-row form where they could record their values and use those values in the where clause of the SQL for the report, but that is a somewhat complex solution I have never tried before. how to do this. I'm working in the latest version 4 of APEX.

View 1 Replies View Related

Application Express :: How To Order  X-axis In Multiple Series Chart

Aug 17, 2012

I am using apex 4.1, i created a chart with 4 series in each series i am calculating sum of the no.of students joining in different classes of a institute for every year.

example my table is like this
date_of_join     class    student_id
'07/22/2012'      8       1
'07/22/2011'      8       2
'07/22/2009'      8       3
'07/22/2012'      7       4
'07/22/2010'      7       5
'07/22/2011'      6       6i wrote query like
series1

select null as link,UNISTR('�0A0') || to_char(date_of_join,'YYYY'),count(student_id) "class 8" from stdent_record where class=8 group by to_char(date_of_join,'YYYY') order by to_char(date_of_join,'YYYY')

series2

select null as link,UNISTR('�0A0') || to_char(date_of_join,'YYYY'),count(student_id) "class 7" from stdent_record where class=8 group by to_char(date_of_join,'YYYY') order by to_char(date_of_join,'YYYY')but what happened is the x-axis is coming in order like

2009  2011 2012 2010because the series1 no student is joined in 2010 so its taking the series1 order but i need the years in normal order.

View 3 Replies View Related

SQL & PL/SQL :: Inserting Multiple Records With CLOB Using Select

Oct 11, 2013

I'm updating a large piece of legacy code that does the following type of insert:

INSERT INTO foo_temp
(id, varchar2_column)
SELECT id, varchar2_column
FROM foo;

We're changing varchar2_column to clob_column to accommodate text entries > 4000 characters. So I want to change the insert statement to something like:

INSERT INTO foo_temp
(id, clob_column)
SELECT id, clob_column
FROM foo;

This doesn't work, since clob_column stores the location of each text entry, rather than the actual content. But is there some way that I can achieve the insert with one call to a select statement, or do I need to select each individual record in foo, open the clob_column value, read it into a local variable and then write the content to the matching record in foo_temp?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved