Re: Large XML into a SP in Oracle

> 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 - 03:13:52 CDT