Subject SQL transaction handle
Author B.D.S. Bell
Hi everyone,

Can anybody help please, I have a peculiar problem?

I have been using a TIB_StoredProc for some time with no
problems.
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
start)
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 ),

MessageTrn.Commit;

Any help will be most appreciated.

Thanks

Bryan

[Non-text portions of this message have been removed]