I used a dblink like '@dblink' in oracle procedures,but when i recompile it,it faild.And errors are below: ORA-04052:error occurred when looking up remote object OPENEAP.SYS_FILE@V_DBLINK.REGRESS.RDBMS.DEV.US.ORACLE.COM
ORA-00604:error occurred at recursive SQL level1
ORA-02019:connection description for remote database not found
Code in procedure is below:
open cursor_1 for
select * from OPENEAP.SYS_FILE@v_dblink;
<<loop_cvp>>
loop
begin
fetch cursor_1 into vr_sys_file;
exception
when others then
vlog_operate_error_msg := '读取游标失败';
v_object_error_id := base_object_error_id+45;
raise v_userExp;
end;
exit when cursor_1%notfound;
could you please tell me how to solve the problem?thanks!