Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateDDL statements → CREATE EXCEPTION
Firebird Home Firebird Home Prev: CREATE DOMAINFirebird Documentation IndexUp: DDL statementsNext: CREATE GENERATOR

CREATE EXCEPTION

Message length increased

Available in: DSQL, ESQL

Message length increased

Changed in: 2.0

Description: In Firebird 2.0 and higher, the maximum length of the exception message has been raised from 78 to 1021.

Example: 

create exception Ex_TooManyManagers
  'Too many managers: An attempt was made to create more managers than the
   maximum defined in the Limits table. If you really need to create more
   managers than you have now, raise the limit first. However, please consult
   your department''s manager before doing so. Otherwise, your decision may
   be overturned later and the additional manager(s) removed.'

Note

The maximum exception message length depends on a certain system table field. Therefore, pre-2.0 databases need to be backed up and restored under Firebird 2.x before they can store exception messages of up to 1021 bytes.

Prev: CREATE DOMAINFirebird Documentation IndexUp: DDL statementsNext: CREATE GENERATOR
Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateDDL statements → CREATE EXCEPTION