Intermittent ORA-07445 [mdrtst()+6971] When Executing Geometry Query With Ref Cursor (Doc ID 1580388.1)

Last updated on SEPTEMBER 05, 2013

Applies to:

Oracle Spatial and Graph - Version 11.2.0.3 and later
Information in this document applies to any platform.

Goal

 Executing the following:

select distinct CBS_CODE, NAAM, 'Automatisch gegenereerd' from dino_lgr.LGR_MAP_NL_WATERSCHAP gis where SDO_RELATE(gis.shape,mdsys.sdo_geometry(2001,NULL,mdsys.sdo_point_type(217940,441923,NULL),NULL,NULL),'mask=ANYINTERACT querytype=WINDOW') = 'TRUE'

Intermittently, results in ORA-07445: exception encountered: core dump [mdrtst()+6971] error.

Solution

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