Subject Re: [ib-support] Commit Work
Author Doug Chamberlin
At 04/17/2002 08:28 PM (Wednesday), Sandeep wrote:
>How is work commited inside Stor Proc ?

You cannot perform transaction start/commit/rollback from within a stored
procedure. These must be done from the application, itself.

You can signal an exception from a stored procedure which should get caught
by the application so it knows to perform a rollback.