<< ALTER DOMAIN | FB 2.5 Language Reference | CREATE OR ALTER EXCEPTION >>
<< ALTER DOMAIN | FB 2.1 Language Reference | CREATE OR ALTER EXCEPTION >>
<< CREATE DOMAIN | FB 2.0 Language Reference | CREATE GENERATOR >>

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.

See also:
Exception
CREATE OR ALTER EXCEPTION
ALTER PROCEDURE
ALTER TRIGGER
CREATE PROCEDURE
CREATE TRIGGER
DROP EXCEPTION

back to top of page
<< ALTER DOMAIN | FB 2.5 Language Reference | CREATE OR ALTER EXCEPTION >>
<< ALTER DOMAIN | FB 2.1 Language Reference | CREATE OR ALTER EXCEPTION >>
<< CREATE DOMAIN | FB 2.0 Language Reference | CREATE GENERATOR >>