How to convert a CLOB to an XMLType in Oracle
Thursday, June 3rd, 2010
Not much comment to add here; code says it all
PROCEDURE clobToXMLType(myClob IN CLOB)
IS
l_xmlType XMLTYPE;
-- do something
BEGIN
l_xmltype := XMLTYPE.createXML(myClob);
EXCEPTION
WHEN OTHERS THEN
RAISE;
END clobToXMLType;
You can leave a response, or trackback from your own site.
Tags: oracle, plsql, xml
Posted in: Development, quick tips