topic Re: EXTPROC setting for ST_GEOM in Geodatabase Questions

EXTPROC setting for ST_GEOM

yockee — Thu, 13 Jan 2022 08:54:27 GMT

Hi,

I am having problem in querying using ST_GEOM. I have followed the guideline but without result.

Here is the error i get when i do query "select sde.ST_AsText(SDE.ST_Geometry('POINT (10 10)', 0)) from dual;"

I have also modified extproc.ora by adding this line : SET EXTPROC_DLLS=ANY.

But the result is still the same.

Anybody knows what may be the cause ? How to fix this ?

Thanks

Re: EXTPROC setting for ST_GEOM

George_Thompson — Thu, 13 Jan 2022 11:11:13 GMT

Run the following SQL as the SDE user:

SELECT file_spec FROM user_libraries WHERE library_name = 'ST_SHAPELIB';

If the path returned does NOT match your ST_SHAPELIB location, please update it:

CREATE or REPLACE LIBRARY ST_SHAPELIB AS '<Location of ST_SHAPELIB file>';

Then:

ALTER PACKAGE sde.st_geometry_shapelib_pkg COMPILE REUSE SETTINGS;

https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/configure-oracle-extproc.htm

This would work if you have already run the Create Enterprise Geodatabase or Create Spatial Type GP tools.

Re: EXTPROC setting for ST_GEOM

PamelaLandy — Tue, 29 Mar 2022 20:43:29 GMT

I have done the procedure for the st_shapelib library. But the query :
select sde.ST_AsText(SDE.ST_Geometry('POINT (10 10)', 0)) from dual
is only correct for me for SDE schema. For other schemes I get error.
What can be caused this ?

Re: EXTPROC setting for ST_GEOM

George_Thompson — Wed, 30 Mar 2022 12:15:54 GMT

If it works in the SDE schema, it is configured properly (as far as I know).

To be honest - I have not run it from another schema.