| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
