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

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.1 [Release 11.1 to 11.2]
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 table1a , table2 b , table3 c , table4 d
WHERE a.empresa = b.empresa
AND a.processo = c.processo
AND a.documento = d.documento
AND (
d.doc IN (:"SYS_B_00", :"SYS_B_01", :"SYS_B_02", :"SYS_B_03", :"SYS_B_04", :"SYS_B_05")
OR d.doc IN (:"SYS_B_06", :"SYS_B_07")
AND c.produto IS NOT NULL
)
AND cproduto IN (:"SYS_B_08", :"SYS_B_09")
AND ( d.publicacao IS NOT NULL OR c.produto IS NOT NULL )
AND CONTAINS(c.produto,TRANSLATE(:"SYS_B_10",:"SYS_B_11",:"SYS_B_12")) > :"SYS_B_13"
AND c.produto is not null;


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




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