Re: Large XML into a SP in Oracle

charles b black wrote:

> 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

If it is not too large ... post it here if you don't mind so that everyone can see it.

Daniel Morgan Received on Fri Apr 18 2003 - 20:21:21 CDT