Re: Table not accessible through Stored Proc

raghu wrote:
> I am able to run select queries on a table through sql and anonymous
> pl/sql scripts. But cannot run the same query through a stored
> procedure. I get the error 'PL/SQL: ORA-00942: table or view does not
> exist'.
> What might be the problem?
>
> Thanks.
>

You.

You are not reading documentation.
You are not searching the net
You are not searching the usenet archives.

In order to avoid the 942, grant access
to the table *directly* (not via a role), and next time test after you issued:
set role none

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...