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