XML Database (MOSC)

MOSC Banner

How to insert XMLDATA INTO CLOB Datatype

edited Aug 1, 2010 6:03PM in XML Database (MOSC) 4 commentsAnswered
 Hi,

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center