ORA-29283 - when try utl_file.fremove file which doesn't exist
Hi,
Using 11.2.0.3 and can remove opearating system file using utl_file.fremove.
However throws error ORA-29283 when the file doesn't exist - this is to be expected.
Is there away to check if file exists before issiuing utl_file.fremove command or worse option ignore such errors
not sure what the exception would be in this case
when no_file_found then
null;
?
Thanks
UTL_FILE.FREMOVE('TERMSPRD_EXTRACTS_ARCHIVE',v_file_name);