Re: Table not accessible through Stored Proc

From: amogh <amogh.r_at_gmail.com>
Date: Wed, 25 Jan 2006 14:47:20 +0530
Message-ID: <ZCHBf.10$Lf1.49@news.oracle.com>

Frank van Bortel wrote:
> 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

 > You.

And I thought a few people on this group were rude.

Agreed that posting queries without searching or reading documentation spams the list. Rude replies would just discourage users from posting or visiting this newsgroup. Received on Wed Jan 25 2006 - 03:17:20 CST