Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ESRI ST_GEOMETRY WKT ORA-06522 06520. 00000 - "PL/SQL: Error loading external library"

InfoDocApr 6 2017 — edited Aug 1 2017

I am trying to get the WKT for an ST_GEOMETRY column, which appears to have an SRID of 300002

pastedImage_0.png

ORA-06520: PL/SQL: Error loading external library

ORA-06522: Unable to load DLL

ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 67

ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 118

06520. 00000 - "PL/SQL: Error loading external library"

*Cause: An error was detected by PL/SQL trying to load the external

       library dynamically.

*Action: Check the stacked error (if any) for more details.

But I get the error shown above when I run the st_asText function

SELECT ROUTE_NAME, shape esri_shape_col,

sde.st_srid(shape) sridof_esrishape_col,

sde.st_astext(shape)

FROM LRSN_StateLog where objectid=188;

I welcome advice
This post has been answered by InfoDoc on Apr 6 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 29 2017
Added on Apr 6 2017
#database-key-features, #spatial
19 comments
5,959 views