Posts Tagged ‘Oracle’

oracle apex checkbox select all

Recently I needed to add a check box column to an interactive report on Oracle 4.2. I used the APEX_ITEM functionin my report’s SQL to generate the checkbox, but I needed a Check All option on the column header. Simple, just rename the column header: [input type=”checkbox” onclick=”$f_CheckFirstColumn(this)” /> This was implemented after repeated requests […]

Share
More »

Oracle XMLDB custom authentication for webdav / http

Oh what joy Oracle has brought me today!! I’ve been struggling for a few days trying to work out how best to integrate Oracle and Active Directory to allow users to map a drive letter to Oracle XMLDB to use it as a file store, extract EXIF, lat / lon and so on… I’d finally […]

Share
More »

Oracle on Amazon RDS with APEX listener

I’m in the process of setting up Oracle 11g with APEX and XMLDB on Amazon Web Services. I thought i’d document the process and what i do to get it all (hopefully) working together. Also, this will act as reference document for me when I do it again later this week. So here we go… […]

Share
More »

How to set Oracle Apex Checkbox default value

By Craig Glendenning As often is the case when I blog about something, I spent waaaaay too much time trying to figure out how to do something that is seemingly very simple. In this case my trivial requirement was to create a single checkbox, that when checked, puts “Yes” in the database, and when unchecked, […]

Share
More »

Getting the server name in Oracle 11g

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

Share
More »

Oracle Apex sticky hide and show regions

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

Share
More »

Creating ACLs in Oracle 11g

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

Share
More »

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 »

Exporting an Oracle schema and uploading to Amazon S3

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

Share
More »

Tablespace does not exist

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? […]

Share
More »

Switch to our mobile site