Unanswered: How to send a email/attach with UTL_SMTP ?
Hello to all.
I'm new in ORACLE (First thing that i do )
I need to send a email with UTL_SMPT with a attach file (txt/pdf...).
I found on web a few examples.
I already send a simple email. But when i try to attach some file ... ERROR.
In this moment the error is "FILE doesn't exists".
The example that i use is http://www.oracle.com/technology/sam...ildemo_sql.txt
Funny... all say the same. I already look to that.
Maybe the reason that i don't understand is that i never see pl/sql in my front. And this guys (co-workers), are starting to killing me ...
But, thanks for your replay , lets get reading (again) that stuff..
Another option would be: If you are sending mail locally (which I expect -- I dont really think you're relaying email outside your corporation for security reasons), just put the files on a network share and give permissions to that share to the users you're sending the email and then just let them know where this network path is on the email. (I have done this at a site I happen to assist).
Yes, i use blob.
What i do...
Convert a file in blob
Connect to DB.
upload blob to a temporary table
Use utl_smtp to attach file(blob) (This info i get from "asktom")
close DB connection (temporary table deleted so blob).
Thanks, for your help.
Now, i understand (better) utl_smtp