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;