Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!diablo.voicenet.com!prodigy.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr16.news.prodigy.com.POSTED!10a1c2a2!not-for-mail
Message-ID: <3EE11585.6020601@nospam_netscape.net>
From: Dave Hau <davehau_nospam_123@nospam_netscape.net>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: XDK - root of element expected
References: <ffc8f296.0306061405.7a08b8a5@posting.google.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 40
NNTP-Posting-Host: 66.47.68.26
X-Complaints-To: abuse@prodigy.net
X-Trace: newssvr16.news.prodigy.com 1054938502 ST000 66.47.68.26 (Fri, 06 Jun 2003 18:28:22 EDT)
NNTP-Posting-Date: Fri, 06 Jun 2003 18:28:22 EDT
Organization: SBC http://yahoo.sbc.com
X-UserInfo1: TSU[@I_AO@WQB]\YFJKNNFXBWR\HPCTL@XT^OBPLAH[\RSAANVUEAE[YETZPIWWI[FCIZA^NBFXZ_D[BFNTCNVPDTNTKHWXKB@X^B_OCJLPZ@ET_O[G\XSG@E\G[ZKVLBL^CJINM@I_KVIOR\T_M_AW_M[_BWU_HFA_]@A_A^SGFAUDE_DFTMQPFWVW[QPJN
Date: Fri, 06 Jun 2003 22:28:22 GMT
Xref: core-easynews comp.databases.oracle.server:188935
X-Received-Date: Fri, 06 Jun 2003 15:28:20 MST (news.easynews.com)

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