call from java to PL/SQL package for XML

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:48:06 CST