size limit when using extract on xmltype
I am using 9i Release 2 and I'm trying to extract a large chunk of data from an attribute in an xml message. I have a variable defined as an xmltype and I'm trying to extract the characters into a clob variable.
After playing around with it a bit, extract works fine as long as I'm extracting 65,534 characters or less. If I try to extract 65,535 I get the following error message "ORA-00600: internal error code, arguments: [qmxCreXobWithLU1], [], [], [], [], [], [], []
ORA-06512: at "SYS.XMLTYPE", line 0". If I try 65,536, I get 0 characters returned and finally if I try 65,537, I get 1 character.
It appears that there is a 64k character limit if you want the extract function for an xmltype to work properly. Once you try to retrieve larger than 64k it truncates the data. It truncates very weird though. If you are trying to extract a value that is 500 characters over the 64k limit it doesn't just drop the last 500 characters, it returns the first 500 characters that you are trying to extract.
Is this a configuration item that can be increased or is this internal to Oracle?
Any help you can give me would be greatly appreciated.