Category: Oracle

Improving Performance of Your Oracle Application Express Software 5

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&#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...

SQL*Loader and Tab Delimited Input Data 0

SQL*Loader and Tab Delimited Input Data

There’s a great article by Tom Kyte about loading a tab delimited file into Oracle using SQL*Loader which can be viewed here. It talks about using the hexadecimal character X’9′ (tab character) as the...

Importing Oracle ApEx 3.1 Page Export into ApEx 3.0 Application 0

Importing Oracle ApEx 3.1 Page Export into ApEx 3.0 Application

This is a hack that worked for me on several occasions. Our development environment was upgraded to Oracle ApEx 3.1, but for whatever reason, our production environment was not (it’s still sitting on the...

HTTP Post from Oracle PL/SQL 5

HTTP Post from Oracle PL/SQL

I recently needed to execute a HTTP post from an ApEx application to another web page running as some sort of a service. For added security the web page service only accepted POST requests...