Oracle调用外部动态库的设置方法_动态链接库的静态调用

Oracle调用外部动态库的设置方法由刀豆文库小编整理，希望给你工作、学习、生活带来方便，猜你可能喜欢“动态链接库的静态调用”。

oracle在调用外部动态库时需要设置EXTPROC_DLLS

10G设置方法

修改ORA_HOME/NETWORK/ADMIN/listener.ora SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = PLSExtProc)(ORACLE_HOME = d:oracleproduct10.2.0db_1)(ENVS = “EXTPROC_DLLS=ANY”)--添加此行(PROGRAM = extproc)))

11G设置方法

修改ORA_HOME/hs/admin/extproc.ora SET EXTPROC_DLLS=ANY--设置为ANY

设置完成后，重启监听及数据库服务

# When specifying the EXTPROC_DLLS environment variable to restrict the DLLs # that extproc is allowed to load, you may set EXTPROC_DLLS to one of the # following values: # # * ONLY(maximum security)# # When EXTPROC_DLLS=ONLY:DLL[:DLL], only the specified DLL(s)can be loaded.# # Syntax: SET EXTPROC_DLLS=ONLY:DLL[:DLL] # # * NULL(the default value)# # When EXTPROC_DLLS=, only the DLL(s)in $ORACLE_HOME/bin and ORACLE_HOME/lib # can be loaded.# # Syntax: SET EXTPROC_DLLS= # # * Colon-seperated list of the DLLs # # When EXTPROC_DLLS=DLL[:DLL], the specified DLL(s)and the DLLs in # $ORACLE_HOME/bin and ORACLE_HOME/lib can be loaded.# # Syntax: SET EXTPROC_DLLS=DLL:DLL # # * ANY # When EXTPROC_DLLS=ANY, DLL checking is disabled.# # Syntax: SET EXTPROC_DLLS=ANY