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: , ,
Posted in: Development, quick tips



One Response to “How to convert a CLOB to an XMLType in Oracle”

  1. Alvaro Says:

    January 21st, 2016 at 6:45 pm

    Works excellent. tranks.

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>