ST_TRANSFORM() not working on Oracle database

10-03-2018 12:49 PM
New Contributor

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

0 Kudos
1 Reply
Esri Frequent Contributor

Did you also update the ST libraries to 10.6.1?

You may have to re-validate the package after placing the new library.

What is the OS that Oracle is installed on?

--- George T.