My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 10-Dec-2012***


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
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 ...


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

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