ERROR

ORA-20083: Parameter ST_SRID 8 does not exist in ST_SPATIAL_REFERENCES table

Last Published: April 25, 2020

Error Message

If the specified st_srid parameter is invalid or does not exist when constructing st_geometry objects or using an st_geometry object as an input argument to various st_geometry operators and functions, then Oracle error ORA-20083 is returned.

The following example demonstrates using the st_point operator to construct an st_geometry object as input to the st_intersects operator. The st_point constructor requires a value for the st_srid parameter. In this example, the value equals 8.

Code:
SQL> SELECT name
2 FROM world_countries
3 WHERE sde.st_intersects(shape,sde.st_point(153, -27, 8)) = 1;
SELECT name
*
ERROR at line 1:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-20083: Parameter ST_SRID 8 does not exist in ST_SPATIAL_REFERENCES table.
ORA-06512: at "SDE.ST_POINT", line 151

Cause

A query containing an invalid st_srid value fails to execute and returns the Oracle error ORA-20083 because the specified st_srid parameter value is not a valid spatial reference in the sde.st_spatial_references table.

Solution or Workaround

Set a valid value for the st_srid parameter.

    Article ID:000010438

    Software:
    • Legacy Products

    Receive notifications and find solutions for new or common issues

    Get summarized answers and video solutions from our new AI chatbot.

    Download the Esri Support App

    Discover more on this topic

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options