Posts Tagged ‘plsql’
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;
Tags: oracle, plsql, xml
Posted in Development, quick tips | No Comments »