My Oracle Support Banner

ORA-00600 [kope2upic:null], ORA-00600 [kope2k2ob067] From MDSYS.SDO_RELATE (Doc ID 2851358.1)

Last updated on FEBRUARY 23, 2022

Applies to:

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

Symptoms

A function that calls MDSYS.SDO_RELATE fails with errors on the second and subsequent runs:

-- The function's DDL
create or replace function bug_test return sys_refcursor is
   l_rc sys_refcursor;
begin
   open l_rc for
      select col_1, col_2
      from testtable
      where mdsys.sdo_relate(geom_column,
                                         MDSYS.SDO_GEOMETRY(... ...),
                                         'MASK=ANYINTERACT QUERYTYPE=WINDOW') = 'TRUE';
   return l_rc;
end bug_test;
/

 

 

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