Home » SQL & PL/SQL » SQL & PL/SQL » Problems with DBMS_XMLQUERY
Problems with DBMS_XMLQUERY [message #188884] Tue, 22 August 2006 04:49 Go to next message
Messages: 24
Registered: October 2004
Junior Member
I'm using package DBMS_XMLQUERY.
When I use GETXML function, sometimes I get this error:

ORA-00600: internal error, args: [KSMASG1],[4032],[4032],[],[],[],[],[]

My call si like that:

:result := sys.dbms_xmlquery.getxml(sqlquery => 'select var1, var2, var3 from table where ... ',
metatype => : null);

Sometimes run, sometimes get an error. My sql is not heavy only gets about 10 records.
I think may be a problem of shared memory, similar to ORA-4031 or ORA-4032.
┐Could be a problem of size in shared memory, java_pool_size?. My values are:

shared_pool_size 67108864
shared_pool_reserved_size 3355443
large_pool_size 100663296
java_pool_size 33554432

Any advice about DBMS_XMLQUERY will be greatly apreciatted.

Thanks in advance

Re: Problems with DBMS_XMLQUERY [message #188951 is a reply to message #188884] Tue, 22 August 2006 09:38 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
ORA-00600 => Call Oracle Support

There is a Bug addressing something that looks a lot like the details you report on Bug 4014485.

The fix is an upgrade to one of,, or
Previous Topic: Displaying PAGE N of M through SQL*PLUS Report
Next Topic: horizontal reporting
Goto Forum:

Current Time: Sun Aug 20 06:47:53 CDT 2017

Total time taken to generate the page: 0.08984 seconds