PL/SQL (MOSC)

MOSC Banner

error invoking procedure in another schema containing database link

edited Mar 15, 2019 1:27PM in PL/SQL (MOSC) 3 commentsAnswered

Scenario

2 oracle 12C databases:

on one database: end-user schema A runs a procedure in schema B with the usual default definers rights; A  has execute privileges on procedure B so A can run procedure in B fine until:

procedure in schema B is changed to access table in another database using private database link owned by schema B

this procedure compiles ok; and runs ok invoked by B; but now when invoked from A it falls over at run time with:

ORA-02019: connection description for remote database not found

this is even though this is DEFINER rights procedure; maybe this is a security feature where database links are required to be accessible by  invoker (??); can't see any reference to this in documentation

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center