Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    japan
    Posts
    35

    Red face error come up when i exec the procedure

    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

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    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’;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •