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

Have you ever wanted to pass data to an applicatino process but are fed uphaving to use a temporary global variable like GV_TEMP, or similar as a temporary placeholder for some data you want to pass from the page in javascript? var req = new htmldb_Get( null, 123, ‘APPLICATION_PROCESS=ap_dosomething’, 0 ); req.addParam( ‘GV_TEMP_VARIABLE’,’The value’ ); [...]

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

I’ve been working a bit on Oracle APEX and jQuery intergration over the last couple of years. here is a screenshot of the APEX home page. And another of a sub page ..and one more for luck

1. Vertical centering with line-height ?View Code HTML1 line-height:24px; When you have a container with fixed height you can use line-height property to vertically center the content. 2. Prevent oversized content to break fixed width floated layouts ?View Code HTML1 2 3 #main{ overflow:hidden; } When oversized content (i.e. wide image) is placed in fixed [...]

There is no excerpt because this is a protected post.