UPDATEXML CDATA

From: Tim Arnold <timkarnold_at_comcast.net>
Date: Thu, 11 Mar 2004 07:22:34 -0500
Message-ID: <A4SdnbK8DvMwxM3dRVn-gQ@comcast.com>

Greetings,

I'm using v 9.2.0.2 on WinNT sp6.
I have a table with a column of sys.xmltype. Users are allowed to enter data in one of the nodes. In order to prevent an empty nodes if the user clears the column, I try and use
(xpath,NVL(columnName,to_clob('<![CDATA]>' ) in the updatexml to restore the node, but it escapes and returns the literal CDATA

Does anyone know of a workaround?

Thanks,
Tim Received on Thu Mar 11 2004 - 06:22:34 CST