oraext:query-database tip

After searching Google for a bit a came across this blog post about an issue that many face when using oraext:query-database and getting an internal xpath error. The gist of it is this...when using oraext:query-database, ALIAS YOUR COLUMN...ugh...

example

BAD!!!

oraext:query-database('select something_something from dual',false(),false(),'jdbc/hphc_sbc')

GOOD!!!

oraext:query-database('select something_something as something from dual',false(),false(),'jdbc/hphc_sbc')

Seems its due to the length of the query string...

Namespaced Attributes and XPATHs

 Can across a curious thing yesterday, namespaced attribute.

<pe:headers>

<pe:header tns:name="content-type">application/pdf</pe:header>

<pe:header tns:name="version">22</pe:header>

<pe:header tns:name="content-disposition">12</pe:header>

</pe:headers>

I needed the following..

/pe:headers/pe:header[@tns:name = 'version']

Just a quick tip, looks like common sense but threw me for a minute...

CSS Variables

Good article on CSS Variables

Saving your bacon, Part II

Dropped a package or overwrote one with old code? Flashback can help...if you need get your DBA to grant the following if they can to you:

grant flashback on sys.all_source to YOUR_SCHEMA;

Now execute this sql to get the package back:

select text

    from all_source

    as of timestamp

    to_timestamp('04-SEP-2012 10:30:00', 'DD-MON-YYYY HH24:MI:SS')

    where name = 'YOUR_PACKAGE_NAME'

can save your bacon....

Building your 1st SOA 11g BPEL project...

Quick plug...I'll be presenting at ECOUC come October 17-18. A bit of an APEX departure, i'll be doing the other side of my house, the 11g SOA suite. In the presentation, see how to build a BPEL process. Nothing earth shattering but will give you the basics, see the database adapter, notification system, schematron and what ever else I can fit in 60 minutes. If BPEL isn't your cup o' tea, come for the many apex, database, apps and plsql/sql presentations there this year. Its in Raleigh, NC and I can assure you, October in North Carolina is wonderful.