Oracle Application Express (MOSC)

MOSC Banner

APEX 4.2 and Page 0 Usage - not working

edited Feb 24, 2016 9:11AM in Oracle Application Express (MOSC) 2 commentsAnswered

Problem with APEX 4.2 application

Background:

Page 0: is accepting two arguments P0_ARG1 & P0_ARG2

When the application is run the following URL is used :
https://myserver/mydb_apx/f?p=227:1:0::::P0_ARG1,P0_ARG2:OC4S,01-00

When Page 1 is displayed a "Before Header" process sets up various session variables using the arguments supplied to Page 0

e.g. :APP_TENANT_ID := oc_db.getTenantId(v('P0_ARG1'));

This session variable is then used to query the database and build the page content for display.

Page 1 has a form for logging on - once this form is completed Page 2 is displayed.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center