A script-enabled browser is required for this page to function properly.

About external PL/SQL libraries

External PL/SQL libraries are collections of PL/SQL procedures, functions, and packages that are independent of a report definition. By attaching an external library to a report, you can reference its contents any number of times. For example, you could reference a procedure in an attached library from both a Before Report trigger and a format trigger. This eliminates the need to re-enter the same PL/SQL for each application.

When you associate an external PL/SQL library with a report or another external library, it is called an attached library.

For a detailed example of using an external PL/SQL library in a report, see the chapter titled "Building a PL/SQL Report" in the Oracle Reports Building Reports manual, available on the Oracle Technology Network Oracle Reports Documentation page (http://www.oracle.com/technology/documentation/reports.html).

See also

Creating an external PL/SQL library

Adding a program unit to an open library

Removing a program unit from an open library

About attached libraries