Remove files in pl/sql Oracle 9i
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?
Last edited by simon_shefter; 06-29-2005 at 05:28 AM.
Tom Kyte to rescue
You can have your filenames stored in a GTT and then use utl_file to remove the files.
I use either of these solutions:
- Use the file_api to retrieve a list fo files and delete them individually:
- Run an OS command to delete them:
Click Here to Expand Forum to Full Width