问题描述:
Arcgis ORACLE SDE创建完成后,执行st相关查询,会出现以下问题:
ORA-2895:extproc代理DLL路径。
解决办法:
1.把C:\Program Files (x86)\ArcGIS\Desktop10.2\DatabaseSupport\Oracle\st_shapelib.dll文件复制到D:\app\iso\product\11.2.0\dbhome_1\BIN目录下,'D:\app\iso\product\11.2.0\dbhome_1'为ORACLE所在路径;
2.执行语句create or replace library st_shapelib as 'D:\app\iso\product\11.2.0\dbhome_1\BIN\st_shapelib.dll';
3.执行语句select * from user_libraries,library路径已经配置正确;
4.执行语句select st_astext(shape) from tablename,查询结果正常显示。
参考链接:
http://www.itpub.net/forum.php?mod=viewthread&tid=1940017&page=1