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!

same synonym is not working in procedure

544866Oct 5 2007 — edited Oct 5 2007

A select query which is extracting data from a remote database,is giving me the data. But when I am creating a procedure and using the same select query into a cursor and compiling it it is giving the error that PL/SQL: ORA-00980: synonym translation is no longer valid.
I already checked the synonym and if the synonym is not valid then why this query is giving result outside the procedure.
Please give me the solution or hint to find out the solution.
Regards,
Ritesh Sharma

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 2 2007

Added on Oct 5 2007

7 comments

743 views