hi all...

i faced the error when i exec the procedure

ORA-04054: database link ABC.MY does not exist

i run his procedure in TESTING database, i want
to insert the data into TESTING database whereby data is select from ABC database.

below is one part of my procedure. i using the cursor to select data.
and insert to the table. (mc)

cursor c_photo (p_fid varchar2) is
select docno, nation, mugshot, credt
from ms@ABC.MY
where docno = p_fid

ORA-04054 database link string does not exist
Cause: During compilation of a PL/SQL block, an attempt was made to use a
non-existent database link.
Action: Either use a different database link or create the database link.

Syntax
create_database_link::=
authenticated_clause::=
CREATE
SHARED PUBLIC
DATABASE LINK dblink
CONNECT TO
CURRENT_USER
user IDENTIFIED BY password
authenticated_clause
authenticated_clause
USING ’ connect_string ’
;
AUTHENTICATED BY user IDENTIFIED BY password

i.e.
CREATE PUBLIC DATABASE LINK remote USING ’remote’;