+ -
当前位置:首页 → 问答吧 → 请教,PLSQL调用外部DLL 失败,ORA-28595: Extproc 代理: DLL 路径无效

请教,PLSQL调用外部DLL 失败,ORA-28595: Extproc 代理: DLL 路径无效

时间:2011-09-07

来源:互联网

ORA-28595: Extproc 代理: DLL 路径无效
ORA-06512: 在 "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 70
ORA-06512: 在 "SDE.ST_GEOMETRY_OPERATORS", line 68

View program sources of error stack?
--------------------------------------------------------------
listener.ora:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
      (ENVS="EXTPROC_DLLS=E:\ArcGIS\ArcSDE\ora10gexe\bin\st_shapelib.dll" )---这个“E:\ArcGIS\ArcSDE\ora10gexe\bin\st_shapelib.dll”是可以在本机打开找到文件的
    )
    (SID_DESC =
       (GLOBAL_DBNAME = webgis)
       (ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
       (SID_NAME = webgis )
   )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.238.185.71)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )
--------------------------------------------------------
tnsname.ora:

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
WEBGIS =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.238.185.71)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = webgis)
    )
  )

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

C:\Documents and Settings\Administrator>tnsping EXTPROC_CONNECTION_DATA ---这里也是通的
TNS Ping Utility for 32-bit Windows: Version 10.2.0.4.0 - Production on 07-9月 -
2011 12:30:55
Copyright (c) 1997,  2007, Oracle.  All rights reserved.
已使用的参数文件:
F:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)
(KEY = EXTPROC0))) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO)))
OK (0 毫秒)

作者: zhuanke   发布时间: 2011-09-07

将蓝色字体前的路径改为
(ENVS = EXTPROC_DLLS=ANY)
报错如下
--------------------------------------------------------------
ORA-06520: PL/SQL: 加载外部库时出错
ORA-06522: Unable to load DLL
ORA-06512: 在 "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 70
ORA-06512: 在 "SDE.ST_GEOMETRY_OPERATORS", line 68

View program sources of error stack?

作者: zhuanke   发布时间: 2011-09-07

热门下载

更多