Category Archive for "How to – Apex Explained"

Interesting Apex articles to read

Just posting some links, as an online-reading list Throttled File Loading with Node.js & Oracle Database https://jsao.io/2015/03/throttled-file-loading-with-node-js-oracle-database/ Apex 5 APEX 5 EA Impressions: Custom jQuery / jQuery UI implementations http://www.apex-at-work.com/2015/03/apex-5-ea-impressions-custom-jquery.html APEX 5 EA Impressions: Page Designer (Part 1) http://www.apex-at-work.com/2015/03/apex-5-ea-impressions-pager-designer.html APEX

Read More
Count URL clicks

This is a demonstration of using a two-step dynamic action to track how recently link columns from an APEX report have been clicked, based on a request from a lady I met at the KScope11 conference. The report is based

Read More
Using LDAP for Authentication and Authorization within APEX

One of my current customers would like to use their LDAP (Microsoft Active Directory) server for authentication and authorization of APEX applications. Of course we tried to set up a standard LDAP Authenication that’s available within APEX. But we couldn’t

Read More

Paper “Professional Software Development using APEX”

As announced on Twitter yesterday, my paper titled "Professional Software Development Using Oracle Application Express" has been put online. I'm copying the first two paragraphs of the summary here, so you can decide if you want to read the rest

Read More

3e OGH Apex dag te Zeist

Gisteren het OGH Apex congres te Zeist  bij mogen wonen. Was een erg interessante dag met goede presentaties. Soms lastig om een keuze te maken tussen de drie sessies die gelijktijdig gehouden werden, maar al met al goede presentaties gezien.

Read More

Apex security

APEX_PUBLIC_USER When a user is logged into an APEX application all database operations are performed by a database session connected as APEX_PUBLIC_USER as defined in the DAD setup file (dads.conf). This is true for all authentication schemes. The APEX_PUBLIC_USER user

Read More
How to translate all Apex messages, notifications in an easy way

For one of my current project the customer had the (more than reasonable) requirement that all messages, texts on buttons etc should be displayed in Dutch. And there are really a lot of these messages: Regions, Computations, Validations, Processes etc,

Read More
The trouble of getting APEX on MySQL to work…

In theory it should be so easy…running an APEX application on an Oracle instance with database links to MySQL for retrieving and modifying data. In theory that is, because in practice it is somewhat more cumbersome. I finally got there,

Read More