Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Define apex execution context when called from user-defined form.

bppriveSep 10 2008 — edited Sep 10 2008
I have a pretty (too much) complex page to build. The page is build dynamically by pl/sql in a pl/sql region. The procedure generates a form tag which is posted to a user defined accept function.

I have defined a procedure granted to public which receives as parameters the items (<input ...>) posted by the form action property (<form action="pkg.accept"> for example) and manage thing to do (insert/update) based on the complexity and the way the form is build (like most of people who have coded web pl/sql have already done once in their lifetime). Everything work great.

Now that 95% I need work properly, I would need to access data in the apex session that is not accessible because the execution context (the proc accept in the package pkg above) aren't called by apex but directly. I have so many others ways to do it but the simplest would be an api I can call with the parameters, for example, session, user, app and page which would set the environnement variables and make that the v() function would return me the information I need.

Is there anything that does that job (except internal API)...
This post has been answered by 60437 on Sep 10 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 8 2008
Added on Sep 10 2008
4 comments
565 views