Re: Inserting UML data in Oracle 9i

a_hariram wrote:

> 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

ORA-00600 is an internal Oracle error. Open an iTAR at metalink.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)