Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORACLE 19.16.0.0.0: ORA-21779: duration not active

_jumNov 3 2022 — edited Nov 3 2022

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

grafik.png
This post has been answered by B Hall on Nov 7 2022
Jump to Answer

Comments

Post Details

Added on Nov 3 2022
#database-key-features, #spatial
2 comments
1,605 views
1 mention