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

PL/SQL conversion utility:   Converting PL/SQL libraries attached to a report

Using Reports Builder

To convert a PL/SQL library interactively:

Using the Report Compiler GUI

To convert a PL/SQL library using the GUI version of the Report Compiler:

  1. Double-click the Report Compiler icon.
  2. In the Document Type field, specify PL/SQL Library.
  3. In the Source Type field, specify .PLL.
  4. In the Destination Type field, specify .PLL or .PLX. If you specify .PLD, the V1 or V2 PL/SQL will not be converted.

Note: This feature is included in the Report Compiler to create .PLX files for use with Forms. Currently, Reports does not support the use of .PLX files.

Using the Report Compiler from the command line

To convert a PL/SQL library using the Report Compiler on the command line, type:

report_compiler SOURCE=lib1,lib2,UPGRADE_PLSQL=yes

Parameters

Description

report_compiler

Is the name of the Report Compiler executable on your platform.

lib1,lib2

Is the name of the library(s) you want to convert.

See also

About the PL/SQL conversion utility