How to convert CLOB to XMLType ??
Hi,
I created a table XML_TAB as
SQL> desc xml_tab;
Name Null? Type
----------------------------------------- -------- ----------
DOCID NUMBER
DTD CLOB
XMLDOC CLOB
VALID NUMBER
and I inserted a record in the table.
Now the file inserted at the column XMLDOC, I want to convert it to XMLType. How can I do that.
Some docs says to user XMLType.createXML function......
But when I did it....................
SQL> select xmltype.createxml(xmldoc) from xml_tab
ERROR:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00210: expected '<' instead of '<'
Error at line 1
ORA-06512: at "SYS.XMLTYPE", line 0
ORA-06512: at line 1
What could be the cause of the problem? Am I doing it in a correct way?
-- Jitendra