oracle远程调用函数,Oracle dblink远程调用存储过程、函数、序列

一、dblink远程调用procedure：

1、写了一个调用远端sayHello存储过程的存储过程,远端sayHello存储过程如下:

-- 远端 sayHello 定义如下：

create or replace procedure sayHello(currentTime out varchar) is

begin

select 'Hello World' into currentTime from dual;

end sayHello;

2、实现的sayRemoteHello存储过程如下:

create or replace procedure sayRemoteHello(name varchar, pwd varchar, ip varchar) authid current_user as

sqlstr varchar(1000);

r varchar(100);

begin

sqlstr:='drop database link tlink';

execute immediate sqlstr;

-- sqlstr:= 'create database link tlink connect to scott identified by fj1234 using ''(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.70)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = orcl)))''';

-- SERVICE_NAME 使用 SELECT * FROM GLOBAL_NAME; 可查&#