So you create what appears to be a simple classic SQL report region. It contains a lot of rows so you specify a pretty high number in the “Number of Rows” value under “Report Attributes” “Layout and Pagination”. In this example, I set it to 100. You run the report […]
ApEx
LOV query is invalid in Oracle ApEx 4.1 when using subquery
So you create a List of Values in Oracle Application Express 4.1 using a simple in-line query similar to the one below: SELECT d, r FROM ( SELECT 1 d, 1 r from dual UNION ALL select 2 d, 2 r from dual UNION ALL select 3 d, 3 r […]
Oracle Application Express Error Handling Function
Want to record errors thrown within your Oracle ApEx 4 (and above) application without writing a lot of complicated code? It’s really very easy if you utilize Oracle ApEx’s built in functionalities, which in this situation are Error Handling Function and Team Development. With a small piece of code, we […]
How to Create Page Zero in Oracle Application Express 4.1
Page zero is a useful page in Oracle ApEx that gets executed for every page request in your application. It can be utilized if theres a certain component or function (eg. computation, validation, region, etc.) in your application that is common to all your pages. To create page 0, do […]
Oracle ApEx 4.1 Incorrect Sort Order Image for Classic Reports
We recently upgraded our Oracle ApEx installation to 4.1. No major issues but a significant annoyance is that when you click on a sortable column on a classic report, the sort image (up and down arrow/pointers) are reversed. It appears that the problem is currently not patched by Oracle, but […]
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 each variable individually use the following syntax: OWA_UTIL.get_cgi_env(VARIABLE_NAME) eg. OWA_UTIL.get_cgi_env(‘REQUEST_PROTOCOL’) […]