Re: Calling Database Function from FORMS

You can't call the function via an in-line SQL statement, a la:

 select function(argument) into var from dual;

but you certainly can call it via a PL/SQL block:

declare
 return_arg number;
begin
 return_arg := function(argument);
end;

I do this all the time.

Alan

Maarten Scharroo wrote:

> Hi Eric,
>
> You are able to call a stored procedure from FORMS using the FORMS_DDL
> procedure. Take note that you can't return values ( except for exceptions )
> from the stored procedure.
>
> Maarten
>
> Eric Cooper wrote:
>
> > I have a function defined in my database schema that takes two dates as
> > parameters. I want to call this function from FORMS 4.5, but when I try
> > to compile I get an error stating that the function can not be used in
> > SQL. I'd rather not have the function in both the database and the
> > application as it will make maintenance more difficult. Is there a way
> > to call a database function from FORMS???
> >
> > TIA
> > Ed Jennings
> >
> > --
> > The opinions expressed here are my own, not those of Domain Technologies
Received on Thu Mar 19 1998 - 00:00:00 CET