I am getting the following error when executing
SELECT sde.ST_TRANSFORM(:new.SHAPE, 4326) INTO latlon from dual;
within a trigger.
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
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?