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!

ORA:00942:PL/SQL:table or view does not exist

923264Mar 22 2012 — edited Mar 22 2012

Hi

I have a package with 5 procedures.I am trying to change the code for 2 procedures by adding additioanl select statement to the procedures.I am getting the following error when I try to execute the package.
I dont know where the problem is present

ORA:00942:PL/SQL:table or view does not exist

I do have access to the table/view which is present in different schema as I am able to see the data in the schema.Please help me in resolving this issue.

Thanks in Advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 19 2012

Added on Mar 22 2012

19 comments

13,983 views