--- In firebird-support@yahoogroups.com, "johnsparrowuk"
<jsparrow@e...> wrote:

> Back in the days of IB6 beta and IBX (around yr 2000), you weren't
> supposed to use executable (as opposed to selectable) sprocs because
> of some bug that caused them to occasionally fail (in ibclient??)
>
> Is this fixed now?

John, in FB's gds32 (fbclient now) it was fixed by Ann in November
2001. What about modern IBX... Check TIBSQL.ExecQuery in ibsql.pas,
and if SQLExecProcedure: part of Case still contains idiotic
workaraund (repeat of call in case of exception, which can corrupt you
data if SP makes inserts or incremental updates), change it to simple

SQLExecProcedure:
begin
fetch_res := Call(isc_dsql_execute2(StatusVector, TRHandle, @FHandle,
Database.SQLDialect,
FSQLParams.AsXSQLDA,
FSQLRecord.AsXSQLDA), True);
end;

Best regards,
Alexander.