Skip to Main Content
Forums

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-29291 error when using utl_file.fremove

673497Feb 12 2009 — edited Feb 12 2009
Hello everyone,

I have a procedure that imports xml files on a specific directory. When the import is done I need to delete the files.
I tried using utl_file.fremove('TEST','test.xml') where TEST is my directory name.
However when I run this I get the error ORA-29291 saying that the file removal has failed.

When I create a new file for example in my procedure with utl_file, I am able to delete this new file. I did this test to see if I have enough rights on the operating system to create and delete files.

I'm using oracle 10.2.03 on a Windows machine.
Can anyone please help me to understand why I can delete my test file and why I can't delete te xml file?
What am I overlooking?

Thanks in advance.
regards,
mariane
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2009
Added on Feb 12 2009
10 comments
3,425 views