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!

utl_file.fremove and force flag

Wendy TrompJul 27 2009 — edited Jul 27 2009
I would like to know if I'd get an ORA error if the OS asks for confirmation when I try to delete a file.

This is the situation: the OS is AIX, the directory I am using is writeable for world, but the files are not mine. So on in AIX when I try "rm filename" it asks me for confirmation.
When I use utl_file.fremove to do the same thing I get an ORA-29283: invalid file operation . Changing the file permissions to a+w helps because then I can use utl_file.fremove, but I'd rather have an equivalent of "-f" for the utl_file package.

Does it exist?
Thanks
Wendy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 24 2009
Added on Jul 27 2009
2 comments
1,116 views