Re: Function call

Andrea Bertucci <abertucci_at_aitek.it> wrote in message news:<3C6100A9.24892A1A_at_aitek.it>...
> Hi,
> i'm developing under linux.
> I'm using unixODBC and ODBC oracle driver.
> I've wrote a simple store function: "
> create or replace function provaFA return number is
> begin
> return(1);
> end provaFA;
> "
>
> How I can call it and obtain result value?
> Thanks,
> Andrea.

The normal call to a user defined function is in the general form of:

select function(column_name) from ....

In other words code a select statement like any other select you code in your application. You should be able to test your function as select provaFA from dual;

• Mark D Powell --