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
).
Creating an external PL/SQL library
Adding a program unit to an open library
Removing a program unit from an open library
Copyright © 1984, 2005, Oracle. All rights reserved.