Category Archives: XML

ORA-19110: unsupported XQuery expression

Posted on 22 August 2014 by

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 →

Posted in XML | Tagged , | Leave a comment

ALTER TABLE … MOVE with LOBs and XML

Posted on 18 July 2013 by

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 →

Posted in XML | Tagged , , | Leave a comment

XML functions and namespaces in Oracle 11g

Posted on 30 May 2012 by

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 →

Posted in XML | Tagged , , | 1 Comment

XMLTYPE.TRANSFORM() in Oracle11g

Posted on 18 May 2012 by

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 →

Posted in XML | Tagged , , | Leave a comment