Subject Re: [IBO] SQL transaction handle
Author Helen Borrie
At 07:59 PM 18-06-01 +0100, you wrote:

>Hi everyone,
>Can anybody help please, I have a peculiar problem?
>I have been using a TIB_StoredProc for some time with no
>I've not made any explicit changes to the way the
>transaction works,
>set as Isolation := tiCommitted.
>The input parameters named for the SQL look correct but I
>get the error, on Prepared := true; as...
>Invalid Transaction Handle, (Expecting explicit transaction
>isc error 335544332.
>Before the prepare I have,
> with MessageTrn do
> if not InTransaction then StartTransaction;
>and after the ExecProc, ( which it doesn't reach ),

What is the stored proc's IB_Transaction property set to?


All for Open and Open for All
InterBase Developer Initiative ยท