Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-29283 - when try utl_file.fremove file which doesn't exist

user5716448Aug 24 2012 — edited Aug 24 2012
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);
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2012
Added on Aug 24 2012
5 comments
8,027 views