Technology Articles
While it is not possible to create a database link using LDAP credentials, it is possible to lookup the TNS details through LDAP, which will allow you to create a database link using the TNS entry. Firstly, we need to successfully connect locally to the database using our known LDAP […]
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 […]
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 […]
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 […]
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 […]
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 […]