Category: Binary-, CLOB-, Object Relational Storage

September 5

This is a backup of my post, with the same title, on the AMIS Technology Blog site

It is nagging…

I got an email from that you are able to download the handouts from ODTUG until half September (download them now, 1/2 September they will be archived and you will need an account to access them). Because I am highly interested on XML / XMLDB stuff, I scrolled through the list. My eye caught the presentation of Mr. Ken Atkins. As far as I can see from his picture on his website he looks like a nice, cool guy, but I can’t resist making some remarks here about the slides from his presentation: “XML Data Into and Out of Oracle – Using PL/SQL”. Making these remarks is difficult, I wasn’t there, I don’t know the exact context in which they are said in, but…

Anyway. Hereby some of my pointers, based on this presentation…

August 28

Sometimes I forget the stuff I have learned… And sometimes someone, I am lucky enough (in this case on the OTN XMLDB Forum), is so friendly to point out how silly I am 😉

Last Friday I was testing Binary XMLType Tables in combination with use of an XMLIndex; Both using / being based on an XML Schema. The objects both used namespace references to the, for binary use, registered XML Schema. Whatever I did, it didn’t react as was described in the manuals.

It doesn’t help, that I know now that I should have been more observing to see what XMLSpy had generated as an example XML Instance document, nor the fact that I pinpointed to much on syntax and storage statements.

Luckily, in my mind, always conspicuous on stuff related to namespaces, I was so “smart” to not create a Oracle Support Request, but addressed it via the XMLDB OTN Forum… I was very embarrassed to read about (and afterwards had a good laugh about my mistake) as “Chandra” showed me my failure to see the simplest mistake…

August 28

In this post I wanted to share some methods you can use while manipulating XML data. My XMLType Table example is based on my last posts about XMLIndex and (binary) XML Storage. So if you want some more information I suggest reading up on those as well.

Triggered by a great example from Jonathan Gennick (“Faster, Safer, and Smaller LOBs”) in the September issue of Oracle Magazine.

I used this as a base, manipulating XMLType tables and see what happens if I would do the same, but now on XML objects.