On 23 Oct 2006 at 17:55, Nick Upson wrote:

>The ApiGuide says otherwise at the top of page 318. paraphase "When a
>statement has both input parameters and return values use
>isc_dsql_execute2"

It can be used with both insqlda and outsqlda if your statement
returns one and only one row. If (by any chance) the statement can
return more rows, you should isc_dsql_execute2 with NULL instead of
outsqlda and fetch rows later with isc_dsql_fetch.
But in any case, the error you would get, had to be different.
Something else is wrong with your statement. Perhaps, DSQL parser
don't like space between SP name and parenthesis. Try your statement
with IBExpert or similar tool.

--
SY, Dimitry Sibiryakov.