listener.ora配置如下:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
(ADDRESS = (PROTOCOL = TCP)(HOST = lenovo-xxx)(PORT = 1521))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle11g\product\11.1.0\db_1)
(ENVS = EXTPROC_DLLS=ANY)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = E:\oracle11g\product\11.1.0\db_1)
)
)tnsnames.ora配置如下:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lenovo-xxx)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = ICP)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
(CONNECT_DATA =
(SID = PLSExtProc)
)
)在vs2008下生成一个包含一个函数的DLL(编译为C)
int ora_dll(int a,int b)
{
return a + b;
}在SQLplus下输入:
create or replace library dll_test
as 'C:/ora_dll_test.dll';
/create or replace function dll_out(a binary_integer,b binary_integer)
return binary_integer
as
language C
library dll_test
name "ora_dll"
parameters(a int,b int,return int);
/
select dll_out(10,20) from dual;结果报错:
ORA-06520: PL/SQL: 加载外部库时出错
ORA-06522: Unable to load DLL
只有这两行,网上查了很多东西都没解决这个问题,望高手指点!不尽感谢!
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
(ADDRESS = (PROTOCOL = TCP)(HOST = lenovo-xxx)(PORT = 1521))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle11g\product\11.1.0\db_1)
(ENVS = EXTPROC_DLLS=ANY)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = E:\oracle11g\product\11.1.0\db_1)
)
)tnsnames.ora配置如下:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lenovo-xxx)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = ICP)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
(CONNECT_DATA =
(SID = PLSExtProc)
)
)在vs2008下生成一个包含一个函数的DLL(编译为C)
int ora_dll(int a,int b)
{
return a + b;
}在SQLplus下输入:
create or replace library dll_test
as 'C:/ora_dll_test.dll';
/create or replace function dll_out(a binary_integer,b binary_integer)
return binary_integer
as
language C
library dll_test
name "ora_dll"
parameters(a int,b int,return int);
/
select dll_out(10,20) from dual;结果报错:
ORA-06520: PL/SQL: 加载外部库时出错
ORA-06522: Unable to load DLL
只有这两行,网上查了很多东西都没解决这个问题,望高手指点!不尽感谢!
解决方案 »
- 动态执行sql语句
- 初学xml查询,请大侠们介绍点资料.
- 帮忙看看怎么写这个存储过程?
- 绝对的的难题, 没有遇到过这样问题的人, 很难想象为什么会这样!
- 列出ORACLE客户端注册的服务名
- 菜鸟求助:为何使用自定义函数之后查询效率变的非常低?
- 初学者疑惑:oracle用户权限和数据库设计的问题?请求各位高手耐心解答!!!绝对给分
- servlet里有没有办法同时更新Clob字段和一般字段(不使用sql插入clob)?
- oracle TEMP 临时表空间 各字段值为空
- 关于group by 子句,如group by ‘string’ (string可为任意字符串)
- oracle中pl/sql编程 编写1+2+3+。。。。+100的和??
- 这个JOB如何执行
这个路径对不?