English

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

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.