Home » SQL & PL/SQL » SQL & PL/SQL » Conversion of VARCHAR2 to XMLTYPE possible?
Conversion of VARCHAR2 to XMLTYPE possible? [message #188653] Mon, 21 August 2006 02:29 Go to next message
Messages: 21
Registered: August 2006
Junior Member

I have a webform posting to a procedure.
One of the parameters is in XML format. I am reading in this parameter as a varchar2 first before I call another method which take in xmltype to extract the values.

How do I convert varchar2 to xmltype?

Or is it better for the procedure to take in xml straight?
Re: Conversion of VARCHAR2 to XMLTYPE possible? [message #188668 is a reply to message #188653] Mon, 21 August 2006 03:04 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
  v_xml   xmltype;
  v_vc    varchar2(100) := '<BLOCK><ROW>data</ROW><ROW>More data</ROW></BLOCK>';
  v_xml := xmltype(v_vc);
Previous Topic: Average getting calculated incorrectly using group by grouping sets
Next Topic: How do I...?
Goto Forum:

Current Time: Wed Oct 26 02:49:54 CDT 2016

Total time taken to generate the page: 0.07765 seconds