In an APEX application i’m creating, I’m storing some output files that the public needs to get access to on the XMLDB server. The problem is, when i’m moving my code to production, I need to update the location to send the users to. Previously, I’d used global variables in a Global package to store [...]

Recently had a need for sticky hide/show regions in Oracle Apex 4.1. Here’s how I done it. Add the jQuery cookie library to your page template Added the following line to the hide and show region template ?View Code HTML1 $.cookie(‘#REGION_STATIC_ID#’,$(‘##REGION_STATIC_ID# .hide:first:visible’).length);return false; So my hide and show region template looks like this: ?View Code [...]

In Oracle 10g, network access was pretty easy. Just fire up a UTL_HTTP request and voila, you’re data appears. In 11h, everything is locked down, here is where Access Control Lists (ACLs) come into play. To allow a user to access external resources, i.e. web content, you must create an ACL, assign users or roles [...]

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 [...]

Question: How do I upload an oracle database schema file to s3 from linux command prompt Answer: Download s3cmd run ./s3cmd –configure enter your access key and secret key when prompted run your expdp command as oracle user i.e. expdp sys/password schemas=rivpacs directory=DATA_PUMP_DIR dumpfile=rivpacs100309.dmp logfile=rivpacs100309.log upload to your s3 bucket i.e. ./s3cmd put rivpacs100309.dmp s://mybucketname [...]

Question: I’m testing an import for one customer and while importing the database dump file with Data Pump I’m getting the following error: IMP-00017: following statement failed with ORACLE error 959: IMP-00003: ORACLE error 959 encountered ORA-00959: tablespace ‘_$deleted$24$0′ does not exist How do I remove the impdp message that the tablespace does not exist? [...]

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 [...]

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:

HTTP, HTTPS, FTP, WebDAV including WebDAV Version Control Oracle XML DB is not a separate server; it is an integral part of the Oracle database, providing all of the high-availability, scalability, reliability and unbreakable security features needed to run mission-critical applications. You can use Enterprise Manager to manage and administer XML DB applications. The GUI [...]

Today’s bottom-line business impact of adopting XML technologies is especially important. For any organisation that shares information with its counterparts as a critical part of its delivelables, the creation of a single source of information from which we can deliver to all current and future media will deliver real, sustainable benefits. Faster time to market [...]