oracle dblink的格式

-- 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 存储过程名