Re: Stored Procedures

xgmb_at_sunyit.edu (Gineen Brement) wrote:

> 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

And what version of Forms 3.0 are you running? We use the dos version and just had this same problem. It seems we were running 3.0.16.11.x and that functionality wasn't there. When we upgraded to 3.0.16.12.x everything worked just fine. I was informed that Oracle had made some sort of hack to forms (which uses PL/SQL v1) to allow the v2 functionality.

HTH -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Chris Kasten
Programmer/Analyst (among others...)

#include <sys/std_disclaimer.h>

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Received on Thu Nov 30 1995 - 00:00:00 CET