Database Administration (MOSC)

MOSC Banner

database link issue ORA-06550; PLS-00201

edited Sep 8, 2020 5:08AM in Database Administration (MOSC) 6 commentsAnswered

Dear all,

Im facing following error while executing procedure via database link from database version 12.1 to 12.2.

end;

Error report -

ORA-06550: line 24, column 4:

PLS-00352: Unable to access another database 'LBTCI'

ORA-06550: line 24, column 4:

PLS-00201: identifier 'LB@LBTCI' must be declared

ORA-06550: line 24, column 4:

PL/SQL: Statement ignored

06550. 00000 -  "line %s, column %s:\n%s"

*Cause:    Usually a PL/SQL compilation error.

*Action:

link user has a dba permission on target database... so advises regarding lack of permissions don't work.

If I execute the same procedure from 12.2 via link on 12.2 it works.

the issue comes only when source database version differs from  target.

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