XMLType and ORA-00600
627154Mar 7 2008 — edited Mar 10 2008I am using Oracle 10g XMLDB. We have one table with XMLTYPE column. We are not using any schema for this XMLTYPE column. And also the we are inserting only one type of XML in this table.
It is working fine for most of the cases, but in some insertion it is giving the following error
ORA-00600: internal error code, arguments: [17147], [0x768BA98], [], [], [], [], [], []
ORA-06512: at "SYS.XMLTYPE", line 295
ORA-06512: at line 1
When we went through the contents of the XML, we found that there are 2 tags under one parent tag having more than 4000 characters in them. If we delete some characters from one of the tag, we are able to insert the XML successfully in the table.
In some of the websites i found that there is some restrictions on XML node size like a single node size cannot exceed 64 KB. Is it correct?
Can someone help me in sorting out this issue, or atleast help me in finding the exact cause of this problem