DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Convert XMLTYPE to VARCHAR2 or CLOB?

291527Jun 13 2002

Does anyone know how to convert an XMLTYPE variable to VARCHAR2 or CLOB? I am using the XMLELEMENT function to select XML into an XMLTYPE variable (VARCHAR2 and CLOB will not accept xml from this function). But I would like to convert the xml in the XMLTYPE variable to VARCHAR2 or CLOB. Can anyone please tell me how to do this? The reason is that I would like to call this procedure from MS ADO.

Anthony Sneed
email: anthony.sneed@disney.com

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 12 2002

Added on Jun 13 2002

#general-xml, #xml

2 comments

10,234 views