Dropping Exceptions

Go Up to Stored Procedure Exceptions

To delete an exception, use the following syntax:

DROP EXCEPTION name;

For example, the following statement drops the exception, REASSIGN_SALES:

DROP EXCEPTION REASSIGN_SALES;

The following restrictions apply to dropping exceptions:

• Only the creator of an exception can drop it.
• Exceptions used in existing procedures and triggers cannot be dropped.
• Exceptions currently in use cannot be dropped.

Tip: In isql, SHOW PROCEDURES displays a list of dependencies, the procedures, exceptions, and tables which the stored procedure uses. SHOW PROCEDURE <name> displays the body and header information for the named procedure. SHOW TRIGGERS <table> displays the triggers defined for <table>. SHOW TRIGGER <name> displays the body and header information for the named trigger.