Re: Error Executing function

Functions are "executed" with a SELECT, which is why it worked. Procedures are "executed" with EXECUTE.

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 Tue Nov 09 1999 - 14:53:24 CST