Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    46

    Unanswered: DBLink and remote procedure

    Hi,
    I have procedure which calls function on the another schema using dblink.
    I get error : ora-06550: identifier "package_name.procedure_name@dblink_name" must be declared".
    Both procedure and function are in the pl/sql packages.
    DBLink is setup correctly (select statements work perfect)
    I've found that this can be problem with roles and I added clause 'AUTHID CURRENT_USER' next to 'CREATE OR REPLACE PACKAGE' but it doesn't help.

    Thank you very much for any ideas.
    Szałas

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: DBLink and remote procedure

    Could it be that the dblink user does not have EXECUTE privilege on that package?

  3. #3
    Join Date
    Jul 2003
    Posts
    46

    Re: DBLink and remote procedure

    DBLink user (not the owner of the dblink) has privilage to execute this function.

Posting Permissions

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