有必要在存储过程里创建嘛?
在外面创建好,存储过程中使用即可。
create database link linkname connect to user identified by psw using 'xxx';select * from tbname@linkname where ...;
在外面创建好,存储过程中使用即可。
create database link linkname connect to user identified by psw using 'xxx';select * from tbname@linkname where ...;
execute immediate v_sql;