meta data for this page
  •  

CREATE EXCEPTION

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.