Send e-mail with attachment file

[Hesham Azzam]

Hi,

I want to send email with attachment file like (.doc, .xls .... any file's type). I send email from oracle by using following code :

CREATE OR REPLACE procedure send_emails is
l_maicon utl_smtp.connection;
begin
l_maicon :=utl_smtp.open_connection('localhost');
utl_smtp.helo(l_maicon,'hostname');
utl_smtp.mail(l_maicon,'hisham2778@hotmail.com');
utl_smtp.rcpt(l_maicon,'hisham2778@hotmail.com');
utl_smtp.data(l_maicon,'From: hisham2778@hotmail.com' || utl_tcp.crlf||
'To: hisham2778@hotmail.com' || utl_tcp.crlf ||
'Subject: Email from your manager' || utl_tcp.crlf ||
'You have received this mail from your manager');
utl_smtp.quit(l_maicon);
end;

previous code sending the e-mail, but how I can send the attachment file.

Thank You

Hesham Azzam

[tabreaz]

this link will be helpful to accomplish your requirement

http://www.oracle.com/technology/sam...tp_Sample.html