Home » Developer & Programmer » JDeveloper, Java & XML » using xmltype with xml
using xmltype with xml [message #91951] Tue, 02 December 2003 06:43 Go to next message
Messages: 1
Registered: December 2003
Junior Member
I am working in oracle 9i version for Red Hat linux version 9
I am using DBMS_xmlSave.InsertXml for inserting records into tables.
I have problem while inserting in XMLType datatype using DBMS_XmlSave.InsertXml method. I am creating XML tag inside Main XML format for XmlType.
At time of inserting record it gives me following error message.

ORA-29532: Java call terminated by uncaught Java exception: oracle.xml.sql.OracleXMLSQLException: 'java.lang.ClassCastException: ' encountered during processing ROW element 0. All prior XML row changes were rolled back. in the XML document.

Without Xmltype Column I have no problem while inserting records.
Note: Above problem occur in oracle for Red Hat Linux version 9
But it is working fine with oracle for Windows XP.
Pls give me solution for this problem.
Re: using xmltype with xml [message #92005 is a reply to message #91951] Sun, 25 January 2004 17:52 Go to previous message
Messages: 2
Registered: January 2004
Junior Member

See the below return that I got at the command prompt.
Enterprise-a$ oerr ora 29532
29532, 00000, "Java call terminated by uncaught Java exception: %s"
// *Cause: A Java exception or error was signaled and could not be
// resolved by the Java code.
// *Action: Modify Java code, if this behavior is not intended.

Note the %s. I think the 5 default special charaters that Oracle recognizes are ' " & < > . This does not include the % sign. I too have had problems using Oracle's XMLType datatype due to special characters. its a little slower, but you may want try CLOB.
Previous Topic: java.lang.NoClassDefFoundError
Next Topic: BC4J ApplicationModule
Goto Forum:

Current Time: Fri Dec 09 21:17:34 CST 2022