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
>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;

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

Helen




All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________