ORA-00600 [17182] followed by ORA-7445[drexuqrymapInsert] when running text query

(Doc ID 2354378.1)

Last updated on JANUARY 29, 2018

Applies to:

Oracle Text - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

ORA-600[17182] , followed by ORA-7445[drexuqrymapInsert] when running text query

----- Current SQL Statement for this session (sql_id=64pr0ptmgp7bn) -----

SELECT type
,country
,label
,postcode
,NULL prefix
,SDO_CS.TRANSFORM(envelope, 4326) envelope
,SDO_CS.TRANSFORM(coordinates, 4326) coordinates
,4326 geometry_srid
,geometry_type
,geometry_ids
,url
,id
,NULL compound_id
,score
,0 distance
FROM (
SELECT ITEM_TYPE type
,COUNTRY_CODE country
,ITEM_LABEL label
,ITEM_POSTCODE postcode
,ITEM_ENVELOPE envelope
,ITEM_COORDINATES coordinates
,ITEM.ITEM_GEOMETRY.GET_GTYPE() geometry_type
,TO_CHAR(ITEM_OBJECTID) geometry_ids
,ITEM.ITEM_URL url
,ITEM.ITEM_ID id
,SCORE(1) score
FROM LV2_ITEM ITEM
WHERE (
CONTAINS (
ITEM_TOKEN
,:condition
,1
) > 0
)
AND (ITEM_PERMISSION <= 0)
ORDER BY ITEM_PRIORITY DESC
,SCORE(1) DESC
,ITEM_ORDER
)
WHERE (ROWNUM < 52)

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