My Oracle Support Banner

ORA-21779 On SDO_GEOM.SDO_AREA Calls After Applying 19.16 Patchset (Doc ID 2889841.1)

Last updated on DECEMBER 31, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 19.16.0.0.0 and later
Information in this document applies to any platform.

Symptoms

SELECT sdo_geom.sdo_area(MDSYS.SDO_GEOMETRY(2001,8307, null, SDO_ELEM_INFO_ARRAY(1,1,1),SDO_ORDINATE_ARRAY(-0.3878,0.2337)), 0.1, 'unit=SQ_MILE') from dual;
*
ERROR at line 1:
ORA-21779: duration not active
ORA-06512: at "MDSYS.SDO_3GL", line 2250
ORA-06512: at "MDSYS.SDO_GEOM", line 2477
ORA-06512: at "MDSYS.SDO_GEOM", line 2524
ORA-06512: at line 1

Changes

 Applied  34133642 - DATABASE RELEASE UPDATE 19.16.0.0.0

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