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
Using Apex Authorization schemes in PL/SQL

The problem with using APEX authorization schemes in PL/SQL has been addressed several times in blogs and forums, but we occasionally still get questions on how to solve this: I have a page where users with admin roles can modify

Read More
Execute PL/SQL code and return content to page (Plugin)

Here is a Dynamic Action plugin for Oracle Application Express (Apex) that lets you execute PL/SQL code in the database, and then send output generated on the server (via calls to the “HTP.P” procedure) back to any element on the

Read More
Autoformat ANY amount item, anywhere

If you’re building a “finance-ey” application you probably have plenty of fields that should show and accept monetary amounts – and quite possibly these items may be implemented in a variety of ways – ordinary apex number items, edit fields

Read More
APEX 5 New Static File Features

In APEX 4 you could upload files – like CSS files, JavaScript files, Images and whatever else you like – into the APEX Repository. When you navigate to Shared Components, there is a Files section that offers three different options:

Read More
APEX 5 New Package Features

To get a proper list of the new packages and API’s APEX 5 provides us, we have to wait for the documentation of course. But if you’re impatient and want to now more, you can get a list of all

Read More
External Table Processor

The External Table Processor [ETP] plugin is a Process type plugin that allows APEX to use a predefined EXTERNAL TABLE to process a “File Browse..” Item. The plugin does the following: obtains a lock for the given EXTERNAL TABLE copies

Read More
APEX 5 New Authorization Evaluation Point Features

In APEX 4 you can define Authorization Schemes. This is a very useful feature to prevent code repetition all over the place. For instance and Authorization Scheme “Is Admin” might use a select on one or more tables (or web

Read More
APEX 5 New Substitution Syntax Features

You’ve probably all heard about XSS, a.k.a. Cross Site Scripting. One of the ways you make yourself vulnerable to XSS is by creating JavaScript in your APEX applications that accepts unescaped user input – either direct or data retrieved from

Read More
APEX 5 New Runtime API Lockdown Features

In APEX 4.x the developer could implement a feature that involves a call to the APEX API. E.g. you could create new pages on the fly if you would like to (just examine an export file for the how-to). You

Read More