Define apex execution context when called from user-defined form.
bppriveSep 10 2008 — edited Sep 10 2008I 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)...