Hi

I have a cgi web service that has the following code (Using a TIBOQuery)
....

with CompleteTransferQuery do begin
IB_Transaction.StartTransaction;
try
if (Prepared = False) then begin
Prepare;
end;

TransferBatchRef := Trim(TransferBatchRef);

ParamByName('TransferBatchRef').AsString :=
TransferBatchRef;
ExecSQL;

IB_Transaction.Commit;
except
on e : exception do begin
IB_Transaction.Rollback;
LogError('Completing receive transaction.
TransferBatchRef : ' + TransferBatchRef + '. ' + e.Message, 'Application');
end;
end;
end;


This is sometimes failing and logging the following message via the
exception handler

07/Feb/2012 10:28:34 - Application - Completing receive transaction.
TransferBatchRef : 931790. Stack overflow

Any ideas what could be causing a 'Stack overflow' in the above and how
could I deal with it?

Thanks
Rob