Online Documentation for SQL Manager for InterBase/Firebird

Exceptions


Exceptions are user-defined errors and messages for use in stored procedures and triggers.

 

When raised by a trigger or a stored procedure, the exception:

  • terminates the trigger or procedure in which it was raised and undoes any actions performed (directly or indirectly) by it;
  • returns an error message to the calling application.

 

 

Exception Editor allows you to define exception properties. It opens automatically when you create a new exception and is available on editing an existing one.

 

To open an exception in Exception Editor, double-click it in the DB Explorer tree.