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 Compile: ORA-00942: table or view does not exist

697731Apr 22 2009 — edited Apr 22 2009

Hello,

My Oracle user_id has the "SELECT_CATALOG_ROLE" associated with it. And, I can indeed SELECT rows from tables like DBA_TAB_COMMENTS.

However, if I try to compile a procedure that contains a SELECT against DBA_TAB_COMMENTS, I get the "ORA-00492 -table or view does not exist". The procedure has the "AUTHID DEFINER" specified.

Just to summarize, the "standalone" SELECT from DBA_TABS_COMMENTS works fine. The same query in a procedure causes the error. I am using the same userid in both cases. The results are the same via SQLPLUS and Enterprise Manager.

What is wrong, please? I have been working on this for quite some time and cannot see what the problem is.

Thanks in advance for your help.
Troy

P.S. Yes, I am a newbie with Oracle though I have quite a bit of experience with other DBMS.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 20 2009

Added on Apr 22 2009

2 comments

1,815 views