Send e-mail with attachment file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Send e-mail with attachment file

  1. #1
    Join Date
    Jul 2006
    Posts
    1

    Post Send e-mail with attachment file

    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

  2. #2
    Join Date
    Sep 2005
    Posts
    278
    this link will be helpful to accomplish your requirement

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width