XDK - root of element expected

From: Shona Helstrom <gingersnap133_at_hotmail.com>
Date: 6 Jun 2003 15:05:41 -0700
Message-ID: <ffc8f296.0306061405.7a08b8a5@posting.google.com>

Hi,

I'm currently running Oracle Client 8.1.7 and using the XDK. I'm trying to parse an XML document that is sent in as a CLOB to a PL/SQL package though ADO. I have a msxml.domdocument called myxml that is set to the following xml

myxml.loadxml = "<?xml
version="1.0"?><ROWSET><ROW><CCRT_CCTY_NUM>1</CCRT_CCTY_NUM><CCRT_EFFECTIVE_DTE>10/18/2003</CCRT_EFFECTIVE_DTE><CCRT_RTE>1.254</CCRT_RTE></ROW></ROWSET>"

When I call the pl/sql package, i send in the myxml.xml to pass in the xml. In side the pl/sql package the xmlparser raises the exception 'start of root expected' error.

Yet if I pass this in as a string/varchar it works fine.

Does anyone have any ideas? Thanks in advance Received on Fri Jun 06 2003 - 17:05:41 CDT