Subject Re: [IBO] Info mesage from a procedure
Author Jason Wharton
Throwing an exception in a stored procedure doesn't necessarily perform a
rollback of your transaction. It would depend on how you programmed it in
your application. It will do an unwind or cancel the work performed by the
stored procedure/triggers, but not a rollback.

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "Ales Kahanek" <ales.kahanek@...>
To: <>
Sent: Tuesday, July 09, 2002 7:26 AM
Subject: RE: [IBO] Info mesage from a procedure

> You cannot send a message to user from a stored procedure. The only thing
> you can is throwing exception (and user can see the exception text), but
> your transaction is rolled back after that. You can read the excellent TI
> sheet Handling errors (I do not remember the name of this document
> but you can find it on the from Helen. There are
> described the issues concerning exceptions in triggers and procedures very
> clearly.
> Ales