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

Posted in XML | Tagged , | Leave a comment

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

Posted in XML | Tagged , , | Leave a comment

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

Posted in XML | Tagged , , | 1 Comment

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

Posted in XML | Tagged , , | Leave a comment