Try creating directory name using forward slashes as 'e:/orant/net80/admin' Check that as a database user you have permissions to access that directory. Also, check that the specified file is not locked by other process (perhaps Oracle itself keeps this file open) Just in case, here is the link to on-line Developer Guide that has complete examples for directory usage http://www-wnt.gsi.de/oragsidoc/doc_805/server.805/a58241/ch_lob.htm#24547 : thank you very much for all your help... we still can't send an attachment, : when calling the attach_file function there is an error: ORA-22285: : non-existent directory or file for FILEOPEN operation : ORA-06512: at "SYSTEM.ATTACH_FILE", line 56 : Yesterday you confirmed me that the syntax for Create Directory was right, : but we still have the above mentioned error... sincerely, I don't know : what to do. Well, it may be a problem in our server... thanks again
|