Application Express :: Variable In Exception?

Jul 13, 2012

I am using Oracle 9i. The code is also PL/SQL cartridge web application code.

My problem is that while trying to assign a value within an exception, it is not being accessed correctly in a Javascript function
It is as if it is not being set. The value stays "N".

CREATE OR REPLACE PACKAGE BODY CIRC_PORT.pk_start_runs IS
v_alert_msg varchar2(1) := 'N';
BEGIN
runjob(param_1,
param_2,

[code]...

The retrieved value, v_alert_msg, should be referenced in a JavaScript function each time a Submit button is hit:

function doSubmit( theForm )
{
var vacpack_error = "'||*v_alert_msg*||'";
if (vacpack_error == "N") / -- ALWAYS DOES THIS -- /
{
<do something>
}
else
{
<do something>

View 2 Replies


ADVERTISEMENT

Application Express :: Exception Handling Pl Packages And APEX Exception Handler

Oct 7, 2013

APEX 4.2Oracle 11g Database We are using the standard exception handler that was introduced in APEX 4.1, and we have code in packages & procedures in the database (following proper processes of keeping code in the database where possible).  When an exception is found in the procedures/ packages/functions, should the APEX application level exception handler catch any errors that occur or should they be handled in the package/procedure/function they occurred in? Why I ask if, we right now have exception handling code in the pl/code bodies BUT they write their errors to the same table that Apex's Exception handler does, but the errors are NOT presented to the user using the APEX exception handling mechanism.

View 2 Replies View Related

Application Express :: Pass Header Variable From OAM To Apex And Read It In Application?

Mar 4, 2013

We have integrated Oracle Access Manager 11gR1 with Oracle Apex 4.1. The OAM-Apex integration is working fine. Now we want an additional header variable to be passed from OAM to the Apex application. This new header variable will be user's sAMAccountName in Active Directory. OAM is integrated with AD and the AD users are successfully able to access the Apex applications.

The three header variables which are configure in OAM right now are:
Header variable name Value
1. OAM_REMOTE_USER $user.userid
2. OAM_REMOTE_USER_EMAIL $user.attr.mail
3. OAM_REMOTE_USER_GROUPS $user.groups

We need an additional header variable as mentioned below:
Header variable name: OAM_SAMACCOUNTNAME
Value: $user.attr.samaccountname

The new header variable was added in the OHS server's dads.conf file like shown below:
=========== dads.conf =============
...
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER_GROUPS
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER_EMAIL
PlsqlCGIEnvironmentList HTTP_OAM_SAMACCOUNTNAME

But we are not able to read the value of this attribute in the Apex application.On the Apex application, we have a text box which shows the value of this header variable. This textbox is attached with the following stored procedure call to fetch the header variable:
===================
begin
:P1_HEADER_VALUE := owa_util.get_cgi_env( 'HTTP_OAM_SAMACCOUNTNAME' );
end;

The textbox shows the correct value if HTTP_OAM_REMOTE_USER is passed to the get_cgi_env method but does not shows anything when HTTP_OAM_SAMACCOUNTNAME is passed to the same method. if I am missing some configuration to pass the HTTP_OAM_SAMACCOUNTNAME haeder variable from OAM to Apex.

View 1 Replies View Related

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 :: Object Type As Application Level Variable

Jan 2, 2013

My question is, if I define an object type (create type ... as object ...) is it possible to hold a variable of this type as the session level? For example, if I am creating an order using multiple web pages, it would be much easier (and intuitive) to create and manipulate an order object than to hold the data in generic collections.

If that is not possible, is there some way to make a generic Apex collection appear more application specific? By this I mean some way to map the columns C001, C002, ... to more intuitive names such as CUST_NO and ORDER_DATE. I had considered possibly creating a view of the APEX_COLLECTIONS view which would rename the columns but then I would also have to create a bunch of instead of triggers if I wanted to update it as well.

View 2 Replies View Related

Application Express :: Set Variable Via Javascript

May 16, 2013

I got a long string (length exceeds 32512) from Javascript, and want to pass the sting to a variable to a item called P_SQL

I use *$x("P_SQL").value* in javascript to set the value, but my process couldn't get the value before I submit, however, when I do submit it reports an error like this : Bad Request

Your browser sent a request that this server could not understand.mod_plsql: /pls/alq/wwv_flow.accept HTTP-400 Value param too long. Length is 216343. Upper limit is 32512

how to handle this conflict ?

View 4 Replies View Related

Application Express :: From Cursor Variable How To Get Into Page

Feb 15, 2013

i am creating an apex page where i have 2 regions. From the Top region stores all fields entered into the bottom region Text fields like first name and last name and address fields are in region 2(bottom).After region 2, i have a add person button.

Once i click add person, that person will get into top i.e region 1.

Now, Region 1 got person1 first name ,last name
person2, first name,last name
etc..

I am not able to display like p1_first_name,p1_laast_name as the list is not stable..it is growing and not showing the person who already got saved..I can retrieve them from DB using a cursor..But from cursor vairable how to get into page vairable..

View 1 Replies View Related

Application Express :: Passing Variable To Javascript

Aug 28, 2013

4.1.2theme 24

I have a .js process in the before header of a page which has this pl/sql process using htp script javascript function {code} 

function check(flag_val){ if(flag_val=="N") 
document.getElementById("btn").disabled = true;
else 
document.getElementById("btn").disabled = false;  } 
{code} 

and then there is the actual pl/sql process which  has a cursor 

{code} 
declareflg varchar2(1);
..begin selectflag into v_flagfrom table where rownum = 1;
-- actual conditions are different but this returns one value.

 Then below using htp package I had html table with something like 

<td align="right">
<button class="btn btn-success" type="button" id="btn"  onclick="check(flg);"
title="Accept Lead" style=" width:50px;">Flag value</button> </td>  
 {code}

For some reason the script function is not called if I use onload. If I change the onload to onclick it works. Also, if I pass check(flg) it does not work. If I use check(''N'') then is works fine. question is how do I pass a pl/sql variable flg in this case to a javascript function as a parameter? I basically, want the value of flg checked on page load and then if it is N then disable the button. Or else keep it enabled.

View 0 Replies View Related

Application Express :: Using A Variable Database Link For Interactive Report

Nov 5, 2013

I have a requirement where users will select an instance (db link) from an apex LOV and the data in an interactive report will query based on the db link selected. I can use a db link in an interactive report query but only if I provide the exact name of the link. If I do something link select * from foo@:P12_ DBLINK it doesn't work. It seems my only option is to use something like apex_collection.create_collection_from_query and then I can build my query with dynamic sql and use a variable for the dblink name. Then I just create an IRR based on my collection. Does that sound like that correct approach and/or am I missing anything?

View 8 Replies View Related

Application Express :: 4.2 Translate (Function And Global Variable Declaration) Data?

May 1, 2013

i 'm using APEX 4.2.1.00.08 and i 'm wondering if there is a way to translate "Function and Global Variable Declaration" textarea. Every other script textarea is available for translation, but not this.

I know that this is code is loaded on header but may contains important alert messages of global functions.

View 1 Replies View Related

Forms :: Implement Exception Handling In Exception Block Of A Trigger

Oct 10, 2011

I have to implement exception handling in the exception block of a trigger, Quote:exception

when ora_java.java_error then
message( 'Unable to call out to java, ' || ora_java.last_error );
ORA_JAVA.CLEAR_EXCEPTION;

when ORA_JAVA.EXCEPTION_THROWN then
ex := ORA_JAVA.LAST_EXCEPTION;
message( Exception_.toString(ex));
-- lv_exception := Exception_.getMessage(ex);

I get an error for the line: 'message( Exception_.toString(ex));'I have imported the java classes FException et IObject with their methods.

I have to create a Web Service Client, so I wonder if the paragraph Quote:when ORA_JAVA.EXCEPTION_THROWN then ex := ORA_ JAVA. LAST_ EXCEPTION; is mandatory.

View 2 Replies View Related

Real Application Clusters :: Java Null Exception While Modifying Scan Listener?

Nov 5, 2013

Getting below error while including TCPS protocal at 1523 port .

 bash-3.2$ srvctl modify scan_listener -p TCP:1521/TCPS:1523Exception in thread "main" java.lang.NullPointerException        at oracle.cluster.impl.scan.ScanFactoryImpl.modifyScanListener(ScanFactoryImpl.java:978)        at oracle.cluster.scan.ScanFactory.modifyScanListener(ScanFactory.java:510)        at oracle.ops.opsctl.ModifyAction.executeSCANListener(ModifyAction.java:1600)        at

[code]...

View 3 Replies View Related

Forms :: Dynamic Variable In Place Of Username In Each Select Statement Throughout Application

Jul 25, 2010

I have a problem that i have hard coded the username.tablename in each select statement of all forms of my application. Now i want to use a dynamic variable in place of username in each select statement throughout the application. The example is:

select * from scott.emp
and i want to write it as:
select * from variable.emp

But at compilation of the form the compiler should know the above variable name.

I have tried to use following select statement but it does not work.

select user into :global.username from user_users

I think perhaps my problem would be solved with Dynamic SQL Statement but i have no experience by using this statement.

View 4 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 :: Get Checked Options Values Via Application Global Arrays?

Apr 26, 2013

how to use checkbox item, and trying to get checked options values via application global arrays. So, this may be quite simple question, but I'm completely stuck here...

When I was looking through various threads and guides, I've encountered checkbox corresponding array names like "g_f01" - "g_f50". And so far i saw that these names are derived from item name in generated HTML code, for example:

<input type="checkbox" name="*f10*" value="3" />

And this one stands for array name "g_*f10*".However, when I tried to do the same thing - i receive item name which looks like "*p_v04*", and therefore, I can't figure out, which array name should I choose to adress it properly.

My generated HTML snippet:

<input type="checkbox" id="P6_ANSWER_0" name="*p_v04*" value="3"/>

View 2 Replies View Related

Application Express :: Display List Of All Users On Page / Accessing Or Using Application

Mar 23, 2013

i want to display a list of all users on a page those currently accessing or using the application. How do i accomplish this requirement?

View 1 Replies View Related

Application Express :: Login Error 7621 - Determine Workspace For Application?

Jul 5, 2013

APEX 4.0 Sometimes, I am getting the below error when I tried to logging into APEX workspace (after giving workspace name, User name and password), Expecting p_company or wwv_flow_company cookie to contain security group id of application owner.

ErrorERR-7621 Could not determine workspace for application (:) on application accept. I found some threads related to this but in different way not exactly when I am getting this error. 

After 2 or 3 times, this error will not come and I can able to logging into workspace What is the cause for this issue?? 

View 1 Replies View Related

Application Express :: ORA-02291 / Constraint Wwv_flows_fk Violated While Application Import

Nov 4, 2013

Each time when I import an application into my workspace in local 10g XE using the APEX 4.2 Application Builder, I get the "ORA-02291, constraint wwv_flows_fk violated..". The application I whant to import  was originally exported from [URL]. I found out, that it has to to with wwv_flow_application_install.get_workspace_id in the installation script, which obviously returns NULL and not my current workspace id as I suppose it should. I replaced wwv_flow_application_install.get_workspace_id by '<my worskspace id>' and then the import does work. 

View 0 Replies View Related

Application Express :: Application Locking - Force Logout All Current Users And Prevent Login

Jun 12, 2012

I have an application that I'd like to prevent activity in after a certain time of day, say 3pm. Is there any way I can force logout of all current users and then prevent re-login until 9am the next day (short of deleting all of their login credentials and then recreating them the next morning)?

View 7 Replies View Related

Application Express :: How To Protect Oracle Application From Code Edit On Client Side Installation

Sep 12, 2013

We have developed an application for our clients,planning to deploy it in client server soon. we have plans to support the application in future,so we want to restrict the clients from any modifications. By Doubt is, 'build_status=Run only' alone,cannot protect our application from client developers to edit our application,

Because though we install our application as 'Run Only' at the time of installation in client instance,we can still import the original application and change the type to 'Build and Run Application',and run the new application as 'Build and Run'.(which is not supposed to) we want to make sure,if there is any way we can protect our application from modifications after client side installation.  

View 1 Replies View Related

Application Express :: Tree View On Application Builder Not Showing

Jul 16, 2012

I have some applications on Apex public workspace (apex.oracle.com), and suddenly the Tree View, on Application Builder stopped showing any content. If I select "Component View", I see the page components, but if I switch to tree view, it shows me only some empty frames.

View 2 Replies View Related

Application Express :: JSON Error When Trying To Redirect To Another Page In Same Application?

Jul 23, 2013

I'm trying to set up a PL/SQL dynamic action that is triggered by clicking on a button.  The dynamic action sets two values in a table and then I would like to redirect to another page.  Setting the values works fine.  The code is below: 

declarel_information varchar2(255) := :P94_FILENAME;BEGINcommit;UPDATE VDI_METADATASET CREATEUSERLISTNAME = l_information,    CREATEUSERLISTON = sysdate();commit;htp.init;owa_util.redirect_url('f?p=&APP_ID.:81:&APP_SESSION.::NO:::');END; The redirect fails with the following eror: "Error: parseerror: JSON.parse: unexpected non-whitespace character after JSON data" 

how to redirect to a page from within PL/SQL .  None of them result in success. 

View 2 Replies View Related

Application Express :: 4.2.0.00.27 Mobile Themes - Add Virtual Keyboard To Application?

Feb 12, 2013

I'm doing a small application in Apex 4.2.0.00.27 mobile themes.

Application is used to search for books.Will work on a PC Windows with touchscreen.

How do I add a virtual keyboard to my application?

View 6 Replies View Related

Application Express :: Error Importing Existing Application Into Production?

Aug 6, 2012

version 4.0.2.00.07

I had an error importing an application into Production that was exported from Development. The application exists and I was trying to replace it.

The error I received was:

ORA-20001: GET_BLOCK Error. ORA-20001: Execution of the statement was unsuccessful.
ORA-20001: Error creating dynamic action sub-action name=&quot;NATIVE_JAVASCRIPT_CODE&quot; id=&quot;9503820976918886&quot;
ORA-02291: integrity constraint (APEX_040000.WWV_FLOW_PAGE_DA_A_AR_FK) violated - parent key not found<pre>
begin wwv_flow_api.create_page_da_event ( p_id =&gt; 9504132415918888 + wwv_flow_api.g_id_offset ,p_flow_id =&gt; wwv_flow.g_flow_id ,p_page_id =&gtI

opened the SQL that was created from the export utility and this is where it errored:

begin
wwv_flow_api.create_page_da_event (
  p_id => 9503820976918886 + wwv_flow_api.g_id_offset
,p_flow_id => wwv_flow.g_flow_id
,p_page_id => 6
,p_name => 'Add tooltip to Numeric filter operators'
,p_event_sequence => 40

[code]....

Unless I'm not understanding this error it means that it can find the ACTION part that is attached to the WHAT part of this Dynamic Action? The Dynamic Action does work when the application is run (in Development)also, there are 3 others that are similar to this one. The export was created by the export utility in the Application Builder.

If I export only the page and import that into Production the import is successful and the page runs correctly. This is error is happening only when I try to import the entire Application.There are many other changes made which is why I was trying to do an Application export/import instead of individual pages.

View 3 Replies View Related

Application Express :: Modify Form Layout Of Existing Application?

Feb 22, 2013

I have to modify the Form layout of an existing application (Application Express 4.0.2.) where the data for each field is retrieved using SQL statements

Presently the form looks something like this and the Data for each field is rendered properly in this layout:

UNIT # :         123456
ADMISSION #: 2012101510         DISCHARGE DATE:                 ADMISSION DATE:
FIRST NAME:   JON                     LAST NAME: DOEFIRST NAME, LAST NAME and UNIT # are all "Display Only" item type.

What I'm trying to do is to move "FIRST NAME" underneath "LAST NAME" and "UNIT #" next to "LAST NAME" This part is very simple. However, the issue I'm having is as soon as the "UNIT #" is moved next to "FIRST NAME", the data for "FIRST NAME" and "LAST NAME" simply disappear

This is how it looks
ADMISSION #: 2012101510         DISCHARGE DATE:                 ADMISSION DATE:
FIRST NAME:                             UNIT #: 123456
LAST NAME:   

I have played around for hours and even created from scratch a new page with a new form using SQL statements to pull the data for each field, only to get the same result.

View 7 Replies View Related

Application Express :: IR Does Not Recognize The Application Item Content Correctly

Aug 22, 2013

I have an application item that receives a web service result. This result is like 'MARIA','JOSE','JESUS'. I'm using this string into the parameters of the interactive report, but this is not recognized. I'm showing the content of the application item into a pl sql region and the content is 'MARIA','JOSE','JESUS', when I include this application item into the query, the IR shows me 'MARIA','JOSE','JESUS' 

View 1 Replies View Related

Application Express :: Button Placement On APEX Application Page?

Mar 6, 2013

How do I center a button within a region? I tried 'align="center"' but this seemed to be ignored. The button is at the left of the screen. Also, what are the 'display points' (Page Template Region Position 1-8) used for, and why is there a specification for column position of 1-9? Could these be attributes that will allow my button to be centered on the window instead of on the left?

View 3 Replies View Related

Application Express :: Raise Application Error On Dynamic Action

Jul 18, 2013

I am using Apex 4.2. On a click of button a Dynamic Action is written, which calls a DB Package. The DB package has exception handlers and also the package has two output parametersError Code and Error MsgSo in my code(Dynamic Code) i make a call to the package and checks the value for Erroc Code.

Begin Package call......  If v_error_code <> '0' Then    Raise SC_Error;  End if;Exception   When SC_Error Then    RAise_Application_error(v_err_code, v_err_msg);End;

But when i run the page and I click I get an Internal exception errorOutput from Debug -- I am not sure what the Cell in Red colour means, because the package is returning a correct message (before the red line).AJAX call returned server error ORA-20003:

Customer has already been matched for Execute PL/SQL Code.4......is_internal_error: true4......apex_error_code: APEX.AJAX_ SERVER_ ERROR4.. ora_ sqlcode: -200034......ora_sqlerrm: ORA-20003: Customer has already been matched4......error_backtrace: ORA-06512: at line 41 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926 ORA-06512: at "SYS.WWV_DBMS_SQL", line 973 ORA-06512: at "SYS.WWV_DBMS_SQL", line 999 ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_EXEC", line 830 ORA-06512: at "APEX_040200.WWV_FLOW_PLUGIN_UTIL", line 2304 ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_ACTION_NATIVE", line 442 4......component.type: APEX_APPLICATION_PAGE_DA_ACTS4......component.id: 231852037977562094......component.name: NATIVE_EXECUTE_PLSQL_CODE4.

Execute Error Handling Callout defined on Page or Application Level4...Execute Statement: begin declare l_error wwv_flow_error_api.t_error; begin l_error := wwv_flow_error_api.g_error; wwv_flow_error_api.g_error_result := apx_error_utils.handleerror ( p_error => l_error ); end; end;4......Values changed by callout:4..

An unexpected internal application error has occurred. Please get in contact with your system administrator and provide reference# for further investigation. 4..display_location: ON_ERROR_PAGE4Stop APEX Engine detected4Final commit4-1 - 59

View 4 Replies View Related

Application Express :: How To Change File Character When Export Application (4.2.1.00.08)

Feb 5, 2013

I need to change "File Character" when I export application with Apex 4.2.1.00.08 version, but this option, is not possible. The ComboBox already select with

"Unicode UTF-8]', but I need "ISO-8859-1 - Europa Ocidental",

how can I do change it?

View 1 Replies View Related

Application Express :: Getting Application Items To Work With Login

Jun 20, 2012

I've been creating numerous sample applications. In my latest one, I've been working on custom security schema and it's been working great for the most part. The one issue I'm having is passing login values into my application items. Though I don't receive any error messages or anything, upon checking the value of the application items via the session button, they never contain anything. The code I have in place on my login page is as follows:

begin
select username, user_id
into :F56_USER_NAME, :F56_USER_ID
from GS_USERS
where username = lower( rtrim( ltrim( :P101_USERNAME ) ) );
[code].........

View 8 Replies View Related







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