Re: Error Executing function

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 Tue Nov 09 1999 - 16:29:39 CST