VALIDATE_LAYER_WITH_CONTEXT Throws Error ORA-00904 SDO_GEOM.VALIDATE_GEOMETRY_WITH_SRID Invalid Iden (Doc ID 1597749.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

VALIDATE_LAYER_WITH_CONTEXT throws error ORA-00904 SDO_GEOM.VALIDATE_GEOMETRY_WITH_SRID invalid identifier

SQL Error: ORA-29400: data cartridge error
ORA-00904: "SDO_GEOM"."VALIDATE_GEOMETRY_WITH_SRID": invalid identifier


Complete error stack:

Error starting at line 18 in command:
call SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT('mdf_catalog_tab', 'catalog_source_location', 'geom_valid_results')
Error report:
SQL Error: ORA-29400: data cartridge error
ORA-00904: "SDO_GEOM"."VALIDATE_GEOMETRY_WITH_SRID": invalid identifier
ORA-06512: at "MDSYS.SDO_3GL", line 1475
ORA-06512: at "MDSYS.SDO_GEOM", line 2886
ORA-06512: at line 1
29400. 00000 - "data cartridge error\n%s"
*Cause: An error has occurred in a data cartridge external procedure.
  This message will be followed by a second message giving
  more details about the data cartridge error.
*Action: See the data cartridge documentation
  for an explanation of the second error message.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms