Home » SQL & PL/SQL » SQL & PL/SQL » Problem of ORA-00942
Problem of ORA-00942 [message #289502] Sat, 22 December 2007 17:37 Go to next message
Messages: 3
Registered: December 2007
Junior Member
Hi i am not very strong at PL/SQL ->

I am getting the following error while executing this procedure

150/6 PL/SQL: SQL Statement ignored
150/18 PL/SQL: ORA-00942: table or view does not exist
194/6 PL/SQL: SQL Statement ignored
194/18 PL/SQL: ORA-00942: table or view does not exist

Although the table exist

what are the possible reason that can cause this error..
Please help me out regarding this error..
Re: Problem of ORA-00942 [message #289503 is a reply to message #289502] Sat, 22 December 2007 18:09 Go to previous message
Messages: 25578
Registered: January 2009
Location: SoCal
Senior Member
Are both the SEARCH button on this forum and GOOGLE broken for you?

Privs acquired via ROLEs do NOT apply within PL/SQL procedures.

[Updated on: Sat, 22 December 2007 18:14] by Moderator

Report message to a moderator

Previous Topic: How to catch the exception ORA-00923?
Next Topic: UTIL File Error
Goto Forum:

Current Time: Wed Aug 23 05:13:17 CDT 2017

Total time taken to generate the page: 0.18010 seconds