How to insert XMLDATA INTO CLOB Datatype
As per one of our project requirement, I have to store XMLTYPE Data to CLOB data column. Target table ia_page has template column as CLOB and source ia_web has template as XMLTYPE datatype. I am writing query like :
insert into ia_page(TEMPLATE) select TO_CLOB(XMLELEMENT(TEMPLATE)) from ia_web
This statement inserts blank value "<TEMPLATE> </TEMPLATE>" into target table
Please let me know the correct statement.
Thanks,