Skip Headers
Oracle® Fusion Middleware Publishing Reports to the Web with Oracle Reports Services
11g Release 1 (11.1.1)

Part Number B32121-06
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

C.2 Batch Removing Report Packages

To remove many reports from Oracle Portal at once, do the following:

  1. In a text editor, create a SQL script file (for example, rmv_rdfs.sql) that contains one RWWWVREG.DEREGISTER_REPORT function call for each report definition file package that you want to remove. For example:

    VAR STATUS NUMBER;
    EXEC :STATUS := RWWWVREG.DEREGISTER_REPORT (P_NAME=>'Security');
    EXEC :STATUS := RWWWVREG.DEREGISTER_REPORT (P_NAME=>'Earnings');
    EXEC :STATUS := RWWWVREG.DEREGISTER_REPORT (P_NAME=>'Acc_pay');
    

    Note:

    P_NAME is the name of the report definition file package you want to remove from Oracle Portal.

  2. Start SQL*Plus and log in to the Oracle Portal schema that owns the reports' packaged procedures.

  3. From the SQL*Plus command prompt, execute the script you created in the first step:

    @ rmv_rdfs.sql
    

    The script will execute and remove the packages from Oracle Portal for each report listed in the script.

    Note:

    This procedure will not remove the report definition files from the file system. It only unregisters the reports making them unavailable from Oracle Portal. If you want to remove the files, you must delete them from the file system.