Re: ORACLE*FORMS and stored functions

In article <DvI9xB.MGF_at_news.cern.ch>, Maria SKIADELLI <msk_at_afsmail.cern.ch> wrote:
>I have a function created from SQL*PLUS. I use this function normally from
>PROC*C applications. I tried to call this function from a procedure created in
>forms 4.5. I get back an error saying that the function cannot be
used in SQL.

You didn't give the SQL code you were trying or the error message, so I may not understand the problem correctly. But I think it may be:

  You cannot use a stored function in a select statement. The   following will fail:

    Select MyFunct(col1),col2 from MyTable;

  Instead, you should do something like

     Declare C1 number,C2 number,Temp varchar2(40);
     Begin
       Select col1,col2 from MyTable into C1,C2;
       Temp := MyFunct(C1);
     End;

Note how the function was called outside of the Select statement.

Hope this helps.
Steve Cosner         Received on Fri Aug 02 1996 - 00:00:00 CEST