Subject | UDF returning "SQL procedure" as a function result |
---|---|
Author | legrand_legrand_63 |
Post date | 2006-12-02T20:36:24Z |
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 ?
Regards
PAscal
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 ?
Regards
PAscal