converting and xml string with xmlType
415398Mar 7 2004 — edited Apr 5 2004I have a table that stores XML strings as longs. I am attempting to:
1) convert the xml string to an xmlType; and
2) insert it into an table that stores the xml as an xmltype
New table
test_xmls;
I NUMBER(38)
XMLVAL XMLTYPE
select xml_str into var_xml from table1;
vXML := XMLTYPE(recXML.m_xml);
insert into table2 values (1, vXML);
The problem is that when I go to table2 I only see the first line of the original xml string, the rest of the string is truncated.
Is there an issue with carriage returns in xml strings?
Is there another method of converting?
Cheers?