Chapter 15 DBMS-Specific Features


Defining exceptions in a database package

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

You can create user-defined exceptions linked to the database package behavior.

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) 2007. Sybase Inc. All rights reserved.