Inserting UML data in Oracle 9i

From: a_hariram <member30432_at_dbforums.com>
Date: Thu, 29 May 2003 10:23:22 +0000
Message-ID: <2934990.1054203802_at_dbforums.com>

[Quoted] I have a table with 7 columns, 6 columns are of datatype of VARCHAR2/DATE/NUMBER, one column is of datatype SYS.XMLTYPE. I am trying to insert one record into the table. The insert script is as below:

INSERT INTO t1
VALUES (234556789,1045,0,SYSDATE,SYSDATE,'SYSTEM',XMLTYPE('<GTKL>300<- /GTKL>')); There are no garbage characters in the above insert statement.

When I run this script on UNIX I get the error below:

ERROR at line 1:
ORA-00600: internal error code, arguments: [17177], [0x000000000], [], [], [],
[], [], []

ORA-31011: XML parsing failed
ORA-06512: at "SYS.XMLTYPE", line 0
ORA-06512: at line 1

I verified the ora 31011 which says

31011, 00000, "XML parsing failed"
// *Cause: XML parser returned an error while trying to parse
the document.
// *Action: Check if the document to be parsed is valid.

But the xml document is a valid document. The same insert script works on an NT machine without any errors.
The version of oracle on unix is 9.2.0.3.0.

The characterset is UTF8

I fired the query below to verify:

SQL> select substr(dbms_java.longname(object_name),1,35) as class, SQL> status
from all_o 2 bjects
where obj 3 ect_type = 'JAVA CLASS'
and obje 4 ct_name =
dbms_java.shortname('oracle/xml/parser/v2/DOMParser');

CLASS

---

---

STATUS

---

oracle/xml/parser/v2/DOMParser
VALID Is there any setting (enviroment or any other setting ) needed on UNIX to be able to successfully insert this record in the table. What are the steps I need to do to insert this record.

--
Posted via http://dbforums.com

Received on Thu May 29 2003 - 12:23:22 CEST