Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Error Executing function

Re: Error Executing function

From: Scott Watson <scott.watson_at_home.com>
Date: Thu, 11 Nov 1999 00:46:30 GMT
Message-ID: <GloW3.12058$Q5.425009@news1.rdc1.ab.home.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US