SHOW EXCEPTIONS
From InterBase
Go Up to isql Command Reference
Lists all exceptions or displays the text of a specified exception.
SHOW {EXCEPTIONS | EXCEPTION name};
| Argument | Description |
|---|---|
|
<name> |
Name of an existing exception in the current database |
Description: SHOW EXCEPTIONS displays an alphabetical list of exceptions. SHOW EXCEPTION name displays the text of the named exception.
Examples: To list all exceptions defined for the current database, enter:
SHOW EXCEPTIONS;
Exception Name Used by, Type
================== ========================================
UNKNOWN_EMP_ID ADD_EMP_PROJ, Stored procedure
Invalid employee number or project ID.
. . .
To list the message for a specific exception and the procedures or triggers that use it, enter the exception name:
SHOW EXCEPTION CUSTOMER_CHECK;
Exception Name Used by, Type
=========================== =======================================
CUSTOMER_CHECK SHIP_ORDER, Stored procedure
Overdue balance -- can’t ship.