Hi,

> i've created a store procedure.
> the idea is to raise an error code/message to the user if the procedure
> failed and to raise a message if the procedure succeed.
> i've read the language reference manual, and it said that if used, WHEN

must

> be the last statement in the begin..end block.
>
> i guess i have to assign one variable. but how do this variable know that
> this procedure works well or not.
> fyi, i need to rollback everything if there was an error, if not, then
> commit.

You cannot control transaction from within a stored procedure. All
transaction
control is done by the calling application.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."