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
rony
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
BlackSwan
Messages: 25036
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: Sun Dec 04 04:21:59 CST 2016

Total time taken to generate the page: 0.12098 seconds