Home » RDBMS Server » Server Administration » Delete file created bt UTL_FILE function.
Delete file created bt UTL_FILE function. [message #370676] Tue, 18 January 2000 17:58
Greg Skakun
Messages: 10
Registered: January 2000
Junior Member
Within a PL/SQL block I need to be able to delete a file that was created within the same block using the UTL_FILE. UTL_FILE has no functionality for deleting (in case an Oracle error occurs) or renaming files file.

In addition, if a file is open for write using UTL_FILE when an Oracle error occurs, Oracle automatically closes the file on the exit of the block.

This process is running on an N/T server using 7.3.4 and 8.0.?

I have a FTP service that continually checks for the creation of these files and FTPs the files to another system. I want to delete the files if any errors occur before the FTP process picks them up.
Previous Topic: Re: Why so slow?
Next Topic: Which method is faster!!!!!
Goto Forum:

Current Time: Sun Apr 11 05:38:12 CDT 2021