Re: Error Executing function

try this:

sql> begin

     > forecast_fn;
    > end;
sql> /

Matt Clifford <cliffo13_at_pilot.msu.edu> wrote in message news:38289ea6.55945775_at_news.msu.edu...
> I appreciate your response, but the documentation does state that
> EXECUTE is used to execute a procedure, package, or function and this
> has worked in the past.
>
> The function is actually being called from within our application and
> it works if I connect to the database using SQL Net, but it doesn't
> work when I use Net 8. Although SELECTs and other statements do work
> using Net 8.
>
> Am I way off base thinking that it has something to do with Net 8?
>
>
> On Tue, 9 Nov 1999 15:53:24 -0500, "Alan Shein" <alanshein_at_erols.com>
> wrote:
>
> >
> >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 Wed Nov 10 1999 - 15:49:54 CST