Re: Help! Stored functions

Hai

    I would advice you to create a public synonym for mytable and run the script if you are running the script from other than sys user. grant select privs on the sys.mytable

         bye vinod
vinod_km_at_yahoo.com
Michael Bennett wrote in message
<6m6k7o$5r9$1_at_mendelevium.btinternet.com>...
>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 24 1998 - 04:48:06 CEST