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. You create database package exceptions on the Exceptions tab of a database package using the Add a Row tool.

To view or edit a database package exception's properties, double-click its Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.

The General tab contains the following properties:

Properties

Description

Name/Code/Comment

Identify the object. The name should clearly convey the object's purpose to non-technical users, while the code, which is used for generating code or scripts, may be abbreviated, and should not normally include spaces. You can optionally add a comment to provide more detailed information about the object. By default the code is generated from the name by applying the naming conventions specified in the model options. To decouple name-code synchronization, click to release the = button to the right of the Code field.

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.

Keywords

Provide a way of loosely grouping objects through tagging. To enter multiple keywords, separate them with commas.