Subject Re: [IBO] TIB_SToredProc problems
Author Helen Borrie
At 01:44 PM 22/10/2004 +1000, you wrote:

>I am having some very strange behaviour using the TIB_StoredProc.
>Is it possible to recycle the TIB_StoredProc for multiple Execute

Forget about TIB_StoredProc. Use TIB_DSQL. Use EXECUTE PROCEDURE in your
SQL property, use Execute to execute it, read Fields[] after execution to
read the return values. Use parameters for re-executions of the same proc
and keep it prepared beween re-executions.

There's not much point in recycling a SP or DSQL object; but if you want to
do so with a tib_dsql, you can.