Subject Re: [IBO] Returning value from SP
Author Helen Borrie
At 03:12 PM 28/03/2004 -0700, you wrote:
>Thought there where some difficulties with using an 'exec procedure
>and the advise was to use a 'select value(s) from procedure (parm(s)).
>instead. IB and in Firebird 1.0.x, you can work around the "scrambled
return parameters" bug by using SELECT instead of EXECUTE PROCEDURE. But
you still don't use SUSPEND for a single-line return set. SUSPEND used in
any context except a cursor loop can mess up execution flow, especially if
you have handled exceptions in the code.

This bug is gone from Firebird 1.5 but, if your app is compiled with an IBO
version older than 4.3A, you need to configure OldParameterOrdering true in
firebird.conf. The bug is still present in Firebird 1.0.3 and all IB versions.

Now, the bug you might be referring to is the one where the second and
subsequent executions of EXECUTE PROCEDURE don't properly substitute

This is a client bug and is present in all IB client versions up to and
including 6.0.2 (that I know of -- maybe later versions too) and absent
from Firebird (but upgrade if you are still using a Firebird 0.9nn beta,
for goodness' sake!!). The workaround for *that* bug is to explicitly
unprepare and prepare on each execution.