To remove many reports from Oracle Portal at once, do the following:
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');
P_NAME is the name of the report definition file package you want to remove from Oracle Portal.
Start SQL*Plus and log in to the Oracle Portal schema that owns the reports' packaged procedures.
From the SQL*Plus command prompt, execute the script you created in the first step:
The script will execute and remove the packages from Oracle Portal for each report listed in the script.
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.