AnsweredAssumed Answered

ST_TRANSFORM() not working on Oracle database

Question asked by Thomas.Grothe@iowadot.us_IowaDOT on Oct 3, 2018
Latest reply on Oct 3, 2018 by George_Thompson-esristaff

I am getting the following error when executing 

SELECT sde.ST_TRANSFORM(:new.SHAPE, 4326) INTO latlon from dual;

within a trigger.


Error report:
SQL Error: ORA-20005: Invalid (NULL) Lob locator (points).
ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 740
ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 2728
ORA-06512: at "PTGIS.SKYFIRE_POINT", line 56
ORA-04088: error during execution of trigger 'PTGIS.SKYFIRE_POINT'



this same statement was working just last week before we upgraded to 10.6.1. :new.SHAPE is the just inserted point and latlon is an instance of sde.ST_GEOMETRY. 


Oracle version: 12c

Esri sde version: 10.6.1