-- Drop existing database link
drop database link uy_DBLINK;
-- Create database link
create database link uy_DBLINK
connect to uy
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.108)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)';
java中调用orcl的的存储过程
{CALL uy.pkg_operation_biz.Transfer_user@uy_DBLINK()}
uy 用户
pkg_operation_biz 存储过程的包名
Transfer_user 存储过程名