Re: Large XML into a SP in Oracle

kindaska-
Can you send me a code snippet from VB so I can see how you pass the clob from a vb procedure into a SP?

cbb

On 18 Apr 2003 01:13:52 -0700, kindaska_at_yahoo.com (kindaska) wrote:

>> Whose ODBC driver are you using?
>HI,
>i'm not using an ODBC driver but ORAOLE DB with oracle 8.1.7 client
>
>I think the problem is focused on the DBMS_XML package. In fact i'm
>able to pass the clob from a vb procedure into a SP(or this is what it
>seems..)
>but when the sp try to insert the clob, that is an xml string over
>32K,
>it quits with this error:
>
>executeCommand({call pkg_MYPKG.p_ins(?)})|Errori:-147217900|ORA-29532:
>chiamata Java terminata a causa di un'eccezione Java non ottenuta:
>oracle.xml.sql.OracleXMLSQLException: Start of root element expected.
>ORA-06512: a "DBMS_XMLSAVE", line 67
>ORA-06512: a "PKG_MYPKG", line 31
>ORA-06512: a line 1|OraOLEDB
>
>i've controlled the xml, it's well formed.
>Another test i've done is to reduce the string to less than 32k, and
>transform the sp parameter from clob in a varchar2.. it's all fine, it
>inserts the xml.
>But if i turn the sp parameter again in clob, with the same xml, it
>gives to me the erroro above.
>Some suggestion?!
>Thanks again
Received on Fri Apr 18 2003 - 13:01:57 CDT