Archive for the ‘Coding samples’ Category

Upgrading Oracle Apex 3.2 to Apex 4.0 on Amazon EC2 Cloud

Just today, I upgraded one of my Amazon cloud servers to Application Express 4.0. Few wee problems along the way, but got there in the end. Here is how I did it. Download APEX 4.0 from here Copy the .zip to an S3 bucket Make the bucket public Use PUTTY to log on to the […]

Share
More »

Oracle Apex, jQuery and GIS integration

I recently needed to provide mapping functionality in an APEX app I was developing. In V3+ of Oracle apex, you can create interactive reports like this Now when you click the cog, you geta map icon at the top: I added a <li> element to the interactive report on-the-fly using jQuery (depending if it finds […]

Share
More »

Oracle Apex error – document.wwv_flow.submit is not a function

You might occasionally get this error in Oracle Apex when submitting a page. Alternatively, the page might not submit at all when you click a page button. I must admit this had me stumped and i had to resort to disabling everything, then reenabling region items to find out what was wrong. Turns out that […]

Share
More »

Oracle Pipline functions

Pipelined functions are an extremely useful feature of Oracle 9i and above. They allow you to present disperate nontable based data as a standard table whilst streaming the output so that processing can begin immediately. I.e., they let you SELECT from a function much like you would SELECT from a table. Cool huh? Why would […]

Share
More »

Querying XML in Oracle

Many people seem to have trouble reading XML data within Oracle.

Oracle has a full library of routines built in to allow you to interrogate XML data. Unfortunately, they’re not very well documented.

Just say you have an XML file you want to be able to SELECT from. it looks like this:

Share
More »

Switch to our mobile site