ORA-00600 [kope2upic:null], ORA-00600 [kope2k2ob067] From MDSYS.SDO_RELATE
(Doc ID 2851358.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Spatial and Graph - Version 19.3.0.0.0 and laterInformation 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;
/
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 |