Database Networking (MOSC)

MOSC Banner

21.3 Windows ORA-28595: Extproc agent : Invalid DLL Path

--Oracle Database Enterprise Edition 21.3 on Windows 2019

Problem Description

---------------------------------------------------

SELECT * FROM ALL_LIBRARIES ORDER BY OWNER, LIBRARY_NAME;

/*

OWNER, LIBRARY_NAME, FILE_SPEC, DYNAMIC, STATUS, AGENT, LEAF_FILENAME, ORIGIN_CON_ID

SDE ST_SHAPELIB F:\orahome1\esrilibs\sde109029\st_shapelib.dll Y VALID 3

*/


prompt * Verify st_geometry type (no extproc)

select sde.st_geometry(1,1,1,1,0) from dual;

/*

SDE.ST_GEOMETRY(1,1,1,1,0)(ENTITY, NUMPTS, MINX, MINY, MAXX, MAXY, MINZ, MAXZ, MINM, MAXM, AREA, LEN, SRID, POINTS)

-----------------------------------------------------------------------------------------------------------------------------------------------------------------

ST_GEOMETRY(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, '160000000103000080A8B3D7AB1780A8B3D7AB1790C4D7B90790C4D7B907')

*/


prompt * Verify st_geometry type (extproc)

SELECT sde.st_geometry('point (1 1)', 0) from dual;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center