Category Archives: ApEx
Getting Session Environment Parameters in Oracle
To display all environment variable values for a given oracle session, run the following code: begin FOR i IN 1..owa.num_cgi_vars LOOP htp.p(owa.cgi_var_name(i)||’ : ‘||owa.cgi_var_val(i)); END LOOP; end; The name of the environment variable and value will be displayed. To reference … Continue reading
Oracle ApEx Request That Will Submit Requested Page Though Link
There is a very useful Oracle ApEx REQUEST constant called BRANCH_TO_PAGE_ACCEPT. If included in a URL, the request will process the page as if it was submitted. Now think about this for a minute because this is a useful tool … Continue reading
“Typo” in Oracle ApEx Manage Services Page
Could a developer in Oracle please fix the “typo” in the Manage Services page in Oracle Application Express. I’ve been looking at the error for some time now and was hoping that it will be fixed on the latest ApEx … Continue reading
Convert Oracle ApEx 3.1 Package Export to 3.0
Here’s a useful ASP page which I wrote which will convert an Oracle Application Express 3.1 package export (or page export) to 3.0 automatically! Just in case you developed an application in 3.1, but need to install it in a 3.0 … Continue reading
Improving Performance of Your Oracle Application Express Software
I am writing this article with the thread http://forums.oracle.com/forums/thread.jspa?messageID=3205216� in mind. We have a very large workflow application written in Oracle Application Express, supporting some 3000+ users. This application was written with care, for obvious reasons. Well for one, it’s … Continue reading