【赛迪网－it技术报道】在这个示例中，我们首先做了一个例子，目的是实现以上要求.
首先进行适当授权：
[oracle@jumper oracle]$ sqlplus "/ as sysdba"
sql*plus: release 9.2.0.4.0 - production on tue nov 7 21:07:56 2006
copyright (c) 1982, 2002, oracle corporation. all rights reserved.
connected to:
oracle9i enterprise edition release 9.2.0.4.0 - production
with the partitioning option
jserver release 9.2.0.4.0 - production
sql> grant create public database link to eygle;
grant succeeded.
sql> grant all on dbms_flashback to eygle;
grant succeeded.
|
然后建立db link:
sql> connect eygle/eygle
connected.
sql> create public database link hsbill using 'hsbill';
database link created.
sql> select db_link from dba_db_links;
db_link
---------------------------------------------------
hsbill
sql> select * from dual@hsbill;
d
-
x
|
在此之后我们可以尝试使用db link进行远程和本地执行:
sql> set serveroutput on
sql> set feedback off
sql> declare
2 r_gname varchar2(40);
3 l_gname varchar2(40);
4 begin
5 execute immediate
6 'select global_name from global_name@hsbill' into r_gname;
7 dbms_output.put_line('gname of remote:'||r_gname);
8 select global_name into l_gname from global_name;
9 dbms_output.put_line('gname of locald:'||l_gname);
10 end;
11 /
gname of remote:hsbill.hurray.com.cn
gname of locald:eygle
远程package或function调用也可以随之实现:
sql> declare
2 r_scn number;
3 l_scn number;
4 begin
5 execute immediate
6 'select dbms_flashback.get_system_change_number@hsbill from dual' into r_scn;
7 dbms_output.put_line('scn of remote:'||r_scn);
8 end;
9 /
scn of remote:18992092687
sql>
-the end-
|
闽公网安备 35060202000074号