Re: Help! Stored functions

You have must directly GRANTed access to this table, not access granted via a role. Otherwise your code looks OK to me.

Michael Bennett wrote:
>
> When trying to compile the following function
>
> create function myfunc() AS
> return number;
> temp number;
> Begin
> select into temp count(*) from SYS.MYTABLE;
> return temp;
> End;
>
> The compilation fails with the message SYS.MYTABLE must be declared. The
> table is a valid one (which I have pre created) and any one line SELECT
> statements from the table on the SQLplus command prompt are performed
> succesfully.
>
> Can anyone please tell me how I can include this and other pre created
> tables in my stored procedures and functions?
>
> Thanks
>
> Paul
Received on Wed Jun 17 1998 - 02:02:27 CEST