Chapter 15 DBMS-Specific Features
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. |
![]() |