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..

Report message to a moderator

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: 26766
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 03 11:21:00 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.