ORA-600 [kgeade_is_0] Reported for Select with Bulk Binds (Doc ID 1638228.1)

Last updated on MARCH 28, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.

Symptoms

The following error is encountered in the alert log and trace file:

ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []


In our example, the trace file shows a complex nested query/select called by a user define package body. However, it is possible that different scenarios involving bulk binds will trigger this bug.

Current SQL statement for this session:
SELECT ...
...

---- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
4b56ac2d8      1017  package body CFBFMTPRD01.RWA_MDL_RCE
4b56ac2d8       772  package body CFBFMTPRD01.RWA_MDL_RCE
4db8f7cf8         1  anonymous block
4b1a26ec0        21  anonymous block


The 'Call Stack' section of the trace file includes functions like:

... pfsadrc  opifcr  qersoFetch  qerjotFetch  opifch2  opifch  opipls  opiodr  rpidrus skgmstack  rpidru rpiswu2 rpidrv psddr0 ...


A memory dump section in the trace file shows that the error is related to bulk binds, e.g.:

...
Dump of memory from 0x00000001065ED228 to 0x00000001065ED368
1065ED220                   696E636F 72726563          [incorrec]
1065ED230 7420656C 656D656E 7420636F 6E766572  [t element conver]
1065ED240 73696F6E 00000000 70667361 64633A20  [sion....pfsadc: ]
1065ED250 486F7374 20617272 6179206F 70656E20  [Host array open ]
1065ED260 6661696C 65640000 3A204275 6C6B2062  [failed..: Bulk b]
1065ED270 696E643A 20457272 6F722069 6E206465  [ind: Error in de]
1065ED280 66696E65 00000000 3A204275 6C6B2042  [fine....: Bulk B]
1065ED290 696E643A 20547275 6E636174 65642042  [ind: Truncated B]
1065ED2A0 696E6400 00000000 3A204275 6C6B2062  [ind.....: Bulk b]
1065ED2B0 696E643A 20457272 6F722069 6E206F75  [ind: Error in ou]
1065ED2C0 74206269 6E640000 444D4C20 52657475  [t bind..DML Retu]
1065ED2D0 726E696E 673A2054 6F6F206D 616E7920  [rning: Too many ]
1065ED2E0 726F7773 00000000 3A20444D 4C205265  [rows....: DML Re]
1065ED2F0 7475726E 696E673A 20457272 6F722077  [turning: Error w]
1065ED300 72697469 6E672074 6F20686F 73742076  [riting to host v]
1065ED310 61726961 626C6500 73706163 6520666F  [ariable.space fo]
1065ED320 7220696D 706C6963 69742063 7572736F  [r implicit curso]
1065ED330 72206174 74726962 75746520 636F6C6C  [r attribute coll]
1065ED340 65637469 6F6E0000 20207062 6565766E  [ection..  pbeevn]
1065ED350 643A2070 65726364 65666C20 30782578  [d: percdefl 0x%x]
1065ED360 20706572 63646566                    [ percdef]
...

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms