Re: Stored Procedures

Gineen,

You have to create a synonym for the function name if it is being called by an oracle user other than the owner of the function.

Regards,
Charles_Dye_at_corp.dialog.com

In article <DIv2ou.L47_at_sunyit.edu>, xgmb_at_sunyit.edu (Gineen Brement) writes:
> Hi
>
> We are using Oracle7 and Forms 3.0. I have successfully written, compiled
> and stored a couple of functions which I want to now call from a PL/SQL
> procedure within a form. I'm calling the function with the following
> syntax:
>
> x = function_name(parameters ...)
>
> when the procedure is compiled, I get the following error:
>
> identifier 'FUNCTION' must be declared
>
> HOw can I call a stored procedure in Forms 3.0 within a PL/SQL block.
>
> Thanks
> Gineen Brement, SUNY Utica/Rome
Received on Fri Dec 01 1995 - 00:00:00 CET