Re: XDK - root of element expected

From: Dave Hau <davehau_nospam_123_at_nospam_netscape.net>
Date: Fri, 06 Jun 2003 22:28:22 GMT
Message-ID: <3EE11585.6020601@nospam_netscape.net>

Just want to verify that you're calling parseClob() in your pl/sql package to parse the clob, not parseBuffer().

The signatures of the parse functions for the XML parser in PL/SQL are:

parseBuffer(Parser, VARCHAR2)

parseClob(Parser, CLOB)

Thus parseBuffer() expects VARCHAR2, not CLOB. For CLOB, you have to use parseClob().

HTH. Cheers,
Dave

Shona Helstrom wrote:
> 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:28:22 CDT