Today I got a strange, never seen oracle error: ORA-21779: duration not active.
The simple SELECT is:
SELECT sdo_geom.sdo_length(
sdo_geometry(2002, 8307, NULL, sdo_elem_info_array(1,2,1), sdo_ordinate_array(11,51,11,52))
, 0.01) len
FROM dual;
gives:
Error at line 1
ORA-21779: duration not active
ORA-06512: at "MDSYS.SDO_3GL", line 2250
ORA-06512: at "MDSYS.SDO_GEOM", line 2319
ORA-06512: at "MDSYS.SDO_GEOM", line 2192
ORA-06512: at line 1
After some research I found it as a known bug for SDO_AREA (too) in ORACLE 19.16.0.0.0:
SDO_GEOM.SDO_AREA Fails With An ORA-21779 After 19.16.0.0.220719DBRU (0 Bytes)The solution is:
The bug is fixed in the 23c release. Backports to earlier versions/platforms may be available for download from My Oracle Support.
The bug fix is included in the 19.16 Spatial Bundle patch.34390803, and in the 19.17.0.0.221018DBRU
Have to sic my admin on this patch .
BTW Oracle Live SQL (Version 19.14.0.0.0) calculates the length without objections
