XML Select (XMLGEN - XSU) problem with huge dataset

Hi,

When I use query like :

select xmlgen.getXML('select content_id from bc_content where content_id <
''1400''', 1) from dual

it works. But whenever I give

select xmlgen.getXML('select content_id from bc_content where content_id <
''1500''', 1) from dual

or something more than that, it fails with:

ORA-29532: Java call terminated by uncaught Java exception: oracle.xml.sql.OracleXMLSQLException: ORA-00600: internal error code,

arguments: [kdlseek-kgbtnscb], [], [], [], [], [], [], []
ORA-06512: at "TEST_APP.XMLGEN", line 486
ORA-06512: at "TEST_APP.XMLGEN", line 477
ORA-06512: at line 1

Oracle support almost declines to support XSU! I read somewhere that when the
dataset returned is more than 90K it fails.

I even installed the latest XSU (version 2.1 beta) and still I get the same error.

Does anyone have any idea how to get rid of this? I have trace file generated but I acnnot decipher anything from there.

Thanks and Regards,

NM Received on Wed Feb 14 2001 - 18:34:41 CET