通过dblink访问另一库的外库函数

whtm8868

现有a,b 两库，b库上面可以访问外部库dll文件，现在想通过a库建立dblink到b,然后访问b库上外部库的dll里面的函数，有没办法实现？

Liu Maclean(刘相兵

任何提问 先说数据库版本！！

whtm8868

a库10.2.0.4，b库11.2.0.1

Liu Maclean(刘相兵

FYI

AGENT Clause

Specify the AGENT clause if you want external procedures to be run from a database link other than the server. Oracle Database will use the database link specified by agent_dblink to run external procedures. If you omit this clause, the default agent on the server (extproc) will run external procedures.

Examples

Creating a Library: Examples The following statement creates library ext_lib:

CREATE LIBRARY ext_lib AS '/OR/lib/ext_lib.so';
/

The following statement re-creates library ext_lib:

CREATE OR REPLACE LIBRARY ext_lib IS '/OR/newlib/ext_lib.so';
/
Specifying an External Procedure Agent: Example The following example creates a library app_lib and specifies that external procedures will be run from the public database sales.hq.acme.com:

CREATE LIBRARY app_lib as '${ORACLE_HOME}/lib/app_lib.so'
   AGENT 'sales.hq.acme.com';
/


http://docs.oracle.com/cd/B19306 ... statements_6001.htm