EXTPROC setting for ST_GEOM

529
3
Jump to solution
01-13-2022 12:54 AM
yockee
by
Occasional Contributor

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;"

yockee_0-1642063811845.png

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

1 Solution

Accepted Solutions
George_Thompson
Esri Frequent Contributor

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.

 

--- George T.

View solution in original post

3 Replies
George_Thompson
Esri Frequent Contributor

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.

 

--- George T.
PamelaLandy
Occasional Contributor

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 ?

0 Kudos
George_Thompson
Esri Frequent Contributor

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.

--- George T.
0 Kudos