Compiling the PL/SQL Package to the Database

Many converted Oracle Reports will generate a PL/SQL package specification file and a PL/SQL package body file.

Generated files include:

  • <report_name>S.pls

  • <report_name>B.pls

Run the PL/SQL package files against your Oracle Database using the following commands to create the PL/SQL package specification and body.

SQL> @C:\BIPublisher_reports\invoice\invoiceS.pls
SQL> @C:\BIPublisher_reports\invoice\invoiceB.pls