tags:

views:

31

answers:

0

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!