Remove files in pl/sql Oracle 9i

Hi,
I looking for your help.
The "UTL_FILE.FREMOVE ('USER_DIR', 'userdata2.txt');" command removes one 'userdata2.txt' file. I need to remove all files like 'user*.txt'. Do you know if possible in pl/sql Oracle 9i to delete all files like "file*.txt" ?
Other option is to change permission of created file (-rw-rw-r--) to 777 and delete the file from ksh. If possible to open file with all permission?
Thanks,
Simon.

Check out
http://asktom.oracle.com/pls/ask/f?p...D:439619916584

You can have your filenames stored in a GTT and then use utl_file to remove the files.

Hi.

I use either of these solutions:

- Use the file_api to retrieve a list fo files and delete them individually:

http://www.oracle-base.com/articles/...gFromPLSQL.php

- Run an OS command to delete them:

http://www.oracle-base.com/articles/...sFromPLSQL.php

Cheers

Tim...