| using xmltype with xml [message #91951] |
Tue, 02 December 2003 06:43  |
cysaju
Messages: 1
Registered: December 2003
|
Junior Member |
|
|
Hi
I am working in oracle 9i version 9.2.0.1.0 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 9.2.0.1.0 for Red Hat Linux version 9
But it is working fine with oracle 9.2.0.1.0 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  |
jimbag
Messages: 2
Registered: January 2004
|
Junior Member |
|
|
cysaju,
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
