SQL & PL/SQL

Hi Everyone,

Can sme1 please help me out in solving the following issue:

I have a directory on the server where my database is located and the directory contains only xml files, i need to delete all the files periodically.
N.B: I should not login as sysdba while doing the deletion

I've been trying this code

*******************************
create directory xml_data as 'S:\DCDMC_APPS\DVS\DDW\current\fe\source\reports\out_files'

grant read,write on directory xml_data to xxddw;

exec utl_file.fremove('xml_data','test.xml');
*******************************

But over here, i need to enter the file name manually but for my case, i don't know the files name and i'll have to delete the whole directory.

Can sme1 please help me out

Any kind of help would be much appreciated.

Regards

Nandita