SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
attachment failed

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
attachment failed
Author Message
Leonardo Rozas



Joined: 14 Mar 2001
Posts: 1

Post attachment failed Reply with quote

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

Thu Mar 15, 2001 3:08 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Re: attachment failed Reply with quote

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

Thu Mar 15, 2001 3:37 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.