Re: call from java to PL/SQL package for XML

The str variable is too long for Java or for PL/SQL?

I thought Java has no such restrictions.

As far as PL/SQL is concerned it receives a "sys.xml" type which is ultimately a CLOB.

The size of the file I'm trying to pass is indeed the problem. I created a small file and went on augmenting its size until it failed to be passwd. The critical size is 67070 characters. Does this number remind you (or anyone else) something?

Can it be an oracle listener error or sth? Maybe it can not receive so large packets from any client connection?

regards, thanks a million,
 Sofia

Ï "David Ignjiæ" <dignjic_at_activit.sk> Ýãñáøå óôï ìÞíõìá news:b2iso2$1cu5k9$1_at_ID-73468.news.dfncis.de...
> The str variable is too long you must use CLOB type.
> "Sofia" <list_at_oytis.com> wrote in message
news:b2is3h$e42$1_at_nic.grnet.gr...
> > Hello world,
> >
> > I am trying to call my PL/SQL package in Oracle9i, from my java program:
> >
> > cstmt = conn.prepareCall ("{call
> > XML_UTILS.insert_xml(?,sys.xmltype.createxml('"+str+"'),?,?,?)}");
> >
> > The second argument is the XML file. The actual procedure definition in
> the
> > DB is:
> >
> > procedure insert_xml (doc_type in number,
> > p_doc in sys.xmltype,
> > p_techdocid in INTEGER,
> > o_result_code out INTEGER,
> > o_result_str out VARCHAR2);
> >
> > Although it seems to work fine, I have just had an error - an exception
> when
> > the pre-specified java statement was executed:
> > java.sql.SQLException: ORA-31011: XML parsing failed ORA-19202: Error
> > occurred in XML processing LPX-00231: invalid character 47 ('/') found
in
> a
> > Name or Nmtoken ORA-06512: at "SYS.XMLTYPE", line 0 ORA-06512: at line 1
> >
> > The specific XML file that created the problem has one major difference
> from
> > my other tests: it is > 4000 chars. I do not know whether this is the
> > problem.
> >
> > I would much welcome any ideas on the problem, or even hints on how to
> > continue.
> >
> > Regards,
> > Sofia (Athens, Greece)
> >
> >
>
>
Received on Fri Feb 14 2003 - 08:21:17 CST