topic Re: ST_TRANSFORM() not working on Oracle database in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/st-transform-not-working-on-oracle-database/m-p/870224#M6220 <HTML><HEAD></HEAD><BODY><P>Did you also update the ST libraries to 10.6.1?</P><P></P><P>You may have to re-validate the package after placing the new library.</P><P></P><P>What is the OS that Oracle is installed on?</P></BODY></HTML> Wed, 03 Oct 2018 20:07:33 GMT George_Thompson 2018-10-03T20:07:33Z ST_TRANSFORM() not working on Oracle database https://community.esri.com/t5/geodatabase-questions/st-transform-not-working-on-oracle-database/m-p/870223#M6219 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>I am getting the following error when executing&nbsp;</P><P>SELECT sde.ST_TRANSFORM(:new.SHAPE, 4326) INTO latlon from dual;</P><P>within a trigger.</P><P></P><P>Error report:<BR />SQL Error: ORA-20005: Invalid (NULL) Lob locator (points).<BR />ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 740<BR />ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 2728<BR />ORA-06512: at "PTGIS.SKYFIRE_POINT", line 56<BR />ORA-04088: error during execution of trigger 'PTGIS.SKYFIRE_POINT'</P><P></P><P></P><P>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.&nbsp;</P><P></P><P>Oracle version: 12c</P><P>Esri sde version: 10.6.1</P></BLOCKQUOTE></BODY></HTML> Wed, 03 Oct 2018 19:49:00 GMT https://community.esri.com/t5/geodatabase-questions/st-transform-not-working-on-oracle-database/m-p/870223#M6219 deleted-user-pAO6-stmeoAP 2018-10-03T19:49:00Z Re: ST_TRANSFORM() not working on Oracle database https://community.esri.com/t5/geodatabase-questions/st-transform-not-working-on-oracle-database/m-p/870224#M6220 <HTML><HEAD></HEAD><BODY><P>Did you also update the ST libraries to 10.6.1?</P><P></P><P>You may have to re-validate the package after placing the new library.</P><P></P><P>What is the OS that Oracle is installed on?</P></BODY></HTML> Wed, 03 Oct 2018 20:07:33 GMT https://community.esri.com/t5/geodatabase-questions/st-transform-not-working-on-oracle-database/m-p/870224#M6220 George_Thompson 2018-10-03T20:07:33Z