-
Recent Posts
Archives
Categories
Meta
Category Archives: XML
ORA-19110: unsupported XQuery expression
One of the frustrations I have found with XML functions in the latest Oracle releases is when things that used to be straightforward are now more difficult to achieve. Consider the following simple script that extracts some fields from a … Continue reading
ALTER TABLE … MOVE with LOBs and XML
This week I was asked a question about ALTER TABLE … MOVE in relation to LOB and XML segments. I thought I knew the answer, but wasn’t 100% confident. After some testing I found that it didn’t behave as I … Continue reading
XML functions and namespaces in Oracle 11g
In my last post I described a change in behaviour of XMLTRANSFORM() from Oracle 10gR2 to 11gR1. I have since discovered a similar case, this time when using XML functions to manipulate documents with namespaces. Let’s start with a simple … Continue reading
XMLTYPE.TRANSFORM() in Oracle11g
In a recent upgrade project from Oracle 10gR2 to 11gR2 I came across a change in behaviour of the XMLTYPE.TRANSFORM() function, when namespaces and attributes are involved. Here is a test script to demonstrate the problem: DECLARE xslt XMLTYPE; … Continue reading