--- In firebird-support@yahoogroups.com, "legrand_legrand_63"
<grand.brun.63@...> wrote:

>
> Hello,
>
> I would like to create a C++ UDF that returns the result of a SQL
> procedure, something like:
>
> - select F1('PROC1',param1) from dual;
> - select F2('PROC2',param1,param2) from dual;
> where
> - PROC1 is a SQL procedure with 1 IN and 1 OUT params ,
> - PROC2 is a SQL procedure with 2 IN and 1 OUT params
>
> Which API should I use ?
> - isc_execute ?
>
> Could you redirect me to any API description/user guide or give me any
> advice ?

What is F1 and F2?

I imagine you want something like:

select PROC1(param1) FROM RDB$DATABASE;

and

select PROC2(param1, param2) FROM RDB$DATABASE;

Adam