Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Error Executing function
try from sql*plus
var x number
exec :x := forecast_fn
print x
Scott.
Matt Clifford <cliffo13_at_pilot.msu.edu> wrote in message
news:38287d73.47446754_at_news.msu.edu...
> I am receiving the following error when I try to execute a function in
> SQL Plus 8.0 against Oracle 8.0.5.
>
> SQL> execute forecast_fn;
> begin forecast_fn; end;
>
> *
> ERROR at line 1:
> ORA-06550: line 1, column 7:
> PLS-00221: 'FORECAST_FN' is not a procedure or is undefined
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
>
> However, if I execute the function using a select statement it works.
>
> SQL> select forecast_fn from dual;
>
> FORECAST_FN
> -----------
> 499
>
>
> The user I'm logged in as is the owner of the function, so I don't
> think it has to do with access rights.
>
> Does anyone have any ideas as to why this doesn't work?
>
> Thanks,
> Matt
>
>
Received on Wed Nov 10 1999 - 18:46:30 CST