Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: call from java to PL/SQL package for XML
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 - 07:59:36 CST
![]() |
![]() |