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 - ora-29291

PauloSMOJul 13 2012 — edited Jul 13 2012
Hi;

Oracle 11g - RedHat 5.4

- UTL_FILE.FREMOVE(auxOutDirectory,OutFile) keeps returning ora-29291 (File operation not allowed)
- If I create a directory object in oracle, and grant the permissions, this works ok.

Simples question (I hope):
In this code:
UTL_FILE.FREMOVE(auxOutDirectory,OutFile)
auxOutDirectory is always something under a specific folder: /home/myDiagrams/Study/*/*/*/*

How can I remove any file under the tree /home/myDiagrams/Study/* ?
(Without creating a lot of directory object's in oracle)
BEGIN
         UTL_FILE.fGETATTR(auxOutDirectory,OutFile,myFileExist, myFileLength, myFileBlockSize);
IF ( myFileExist ) THEN
            UTL_FILE.FREMOVE(auxOutDirectory,OutFile);
            UTL_FILE.FRENAME(auxOutDirectory,OutFileTemp,auxOutDirectory,OutFile,TRUE);
ELSE
            UTL_FILE.FRENAME(auxOutDirectory,OutFileTemp,auxOutDirectory,OutFile,TRUE);
END IF;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 10 2012
Added on Jul 13 2012
4 comments
769 views