My Oracle Support Banner

ORA-0600 [7005] on a Select Query Using Contains Clause (Doc ID 1176276.1)

Last updated on MARCH 15, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.1 [Release 11.1 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 10-Dec-2012***

Symptoms

Errors being reported in the alert log:
ORA-00600: internal error code, arguments:  [7005], [0], [], [], [], [], [], [], [], [], [], []

Failing query:
select count(*) FROM table1 a , table2 b , table3 c , table4 d
WHERE a.<col1>= b.<col1>
AND a.<col2>= c.<col2>
AND a.<col3>= d.<col3>
AND (
d.<col4> IN (:"SYS_B_00", :"SYS_B_01", :"SYS_B_02", :"SYS_B_03", :"SYS_B_04", :"SYS_B_05")
OR d.<col5> IN (:"SYS_B_06", :"SYS_B_07")
AND c.<col2> IS NOT NULL
)
AND c.<col2> IN (:"SYS_B_08", :"SYS_B_09")
AND ( d.<col6> IS NOT NULL OR c.<col3> IS NOT NULL )
AND CONTAINS(c.<col3>,TRANSLATE(:"SYS_B_10",:"SYS_B_11",:"SYS_B_12")) > :"SYS_B_13"
AND c.<col3> is not null;


Call Stack:
ForError dbgePostErrorKGE kgeade kgeriv_int kgeriv kgesiv ksesic1 kprcdt rpiacp rpibrv kkexuslfEval kkscsVerifyBindEquivDI kkscsVerifyBindEquivalence kkscsMatchEquivLiterals ...




Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.