Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

procedure calling over remote db failed

shahid_patelAug 4 2022

I have created a procedure on Database B (with commit,rollback) and it is working fine on database b.
but when i am trying to call same from database A getting error "invalid identifier"
i have granted execute as well from Database B to the user of DB link (of Database A)
any idea what i am missing
the DB version of Database B is 19c while database version of Database A is 11.2
thanks

Comments
Post Details
Added on Aug 4 2022
8 comments
343 views