Chapter 12 DBMS-Specific Features


Database package exceptions

PL/SQL allows you to explicitly handle internal and user-defined error conditions, called exceptions, that arise during processing of PL/SQL code.

Exceptions have the following properties:

Properties Description
Name The name of the item which should be clear and meaningful, and should convey the item's purpose to non-technical users.
Code The technical name of the item used for generating code or scripts, which may be abbreviated, and should not generally include spaces.
Comment Additional information about the exceptions.
DB Package Name of the database package to which the exception belongs.
Pragma Allows you to type a compiler directive, that is, a string for specifying compilation parameters for the exception.

 


Copyright (C) 2008. Sybase Inc. All rights reserved.