Regarding to node size in Oracle 10G & data type is XMLTYPE

[siddi]

I am using Oracle 10G. In table one of the column's datatype is XMLTYPE.
And i am storing whole XML into it upto size 1.5MB.
But when i store an XML of size 84KB then the error occurs :
"ORA-00600: internal error code, arguments: [17147], [0xFC5AA68], [], [], [], [], [], [] ORA-06512: at "SYS.XMLTYPE" "

Then i start checking XML file, & i find that two tags contains almost 5000 characters.
If i remove that two tags then XML get stored properly. Even if i delete 2000 characters from that tags then also xml get stored.
My question:
1. Can i increases the size of tags so that it accept more than 4000 character.
2. ANy effective way to store xml in XMLTYPE column without deleting any data..

[Yogeeraj_1]

hi Siddi,

First of all, i would suggest that you contact Oracle Support (as with all ora-600's) to diagnose.

also, have a look at the following url:
http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10790/toc.htm

hope this helps!
kind regards
yogeeraj

[Shrikant Lavhate]

Hi,

Looks you posted in wrong forum. This thread should be under Databases section (http://forums12.itrc.hp.com/service/forums/categoryhome.do?categoryId=149). So that Pros out there may help you.

Best Luck.