Hi Tom,

Below PL/SQL is working fine. while same code of PL/SQL as below is used in Stored procedure compilation error is coming while compiling stored procedure. Could you please make a suggestion to keep below PL/SQL in below Stored Procedure so that Stored procedure compiles successfully.


Script of PL/SQL executes Successfully:
Declare
CURSOR c1 IS SELECT FILENAME FROM table(RDSADMIN.RDS_FILE_UTIL.LISTDIR('DATA_PUMP_DIR')) WHERE MTIME < (sysdate-150) ;
BEGIN
FOR c IN c1 Loop
sys.utl_file.fremove('DATA_PUMP_DIR',c.FILENAME);
END LOOP;
END;
/


Stored Procedure Containing same PL/SQL block as above but getting compilation error while compiling SP:
CREATE OR REPLACE PROCEDURE OldDumpLogClear
AS
Declare
CURSOR c1 IS SELECT FILENAME FROM table(RDSADMIN.RDS_FILE_UTIL.LISTDIR('DATA_PUMP_DIR')) WHERE MTIME < (sysdate-150);
BEGIN
FOR c IN c1
Loop
sys.utl_file.fremove('DATA_PUMP_DIR',c.FILENAME);
END LOOP;
END OldDumpLogClear;
/


Regards,
Keshab Raj Basnet