Re: How to send pdf as attachment with email in oracle

On Monday, January 26, 2015 at 10:59:56 PM UTC+5, Mladen Gogala wrote:
> On Mon, 26 Jan 2015 02:00:55 -0800, wE|rd0 wrote:
>
> > I am successfully receiving email through Oracle but opening the pdf
> > file, I get the error:-
> > "Adobe Reader could not open "ExistingFile.pdf" because it is either not
> > a supported file type or because the file has been damaged(for example,
> > it was sent as an email attachment and wasn't correctly decoded).
> >
> > Below is the code that I am using:-
> >
> > create or replace PROCEDURE mail_attachments_new
> >
> > AS
> > v_From VARCHAR2(80) := 'payslip_at_companyname.com'; v_Recipient
> > VARCHAR2(80) := 'amir.diwan_at_companyname.com';
> > v_Subject VARCHAR2(80) := 'test subject';
> > v_Mail_Host VARCHAR2(30) := '193.10.10.3';
> > v_Mail_Conn utl_smtp.Connection;
> > crlf VARCHAR2(2) := chr(13)||chr(10);
> >
> > BEGIN
> >
> > v_Mail_Conn := utl_smtp.Open_Connection(v_Mail_Host, 25);
> >
> > utl_smtp.Helo(v_Mail_Conn, v_Mail_Host);
> >
> > utl_smtp.Mail(v_Mail_Conn, v_From);
> >
> > utl_smtp.Rcpt(v_Mail_Conn, v_Recipient);
> >
> > utl_smtp.Data(v_Mail_Conn,
> > 'Date: ' || to_char(sysdate, 'Dy, DD Mon YYYY hh24:mi:ss') || crlf
> > ||
> > 'From: ' || v_From || crlf ||
> > 'Subject: '|| v_Subject || crlf ||
> > 'To: ' || v_Recipient || crlf ||
> >
> > 'MIME-Version: 3.1'|| crlf || -- Use MIME mail standard
> > 'Content-Type: multipart/mixed;'|| crlf ||
> > ' boundary="-----SECBOUND"'|| crlf ||
> > crlf ||
> >
> > '-------SECBOUND'|| crlf ||
> > 'Content-Type: text/plain;'|| crlf ||
> > 'Content-Transfer_Encoding: 7bit'|| crlf ||
> > crlf ||
> > 'some message text'|| crlf || -- Message body 'more message
> text'||
> > crlf ||
> > crlf ||
> >
> > '-------SECBOUND'|| crlf ||
> > 'Content-Type: application/pdf;'|| crlf ||
> > ' name="C:\Email\ExistingFile.pdf"'|| crlf ||
> > 'Content-Transfer_Encoding: base64'|| crlf ||
> > 'Content-Disposition: attachment;'|| crlf ||
> > ' filename="ExistingFile.pdf"'|| crlf ||
> > -- crlf ||
> > -- 'PDF,file,attachement'|| crlf || -- Content of attachment
> > -- crlf ||
> >
> > '-------SECBOUND--' -- End MIME mail
> >
> > );
> >
> > utl_smtp.Quit(v_mail_conn);
> > EXCEPTION
> > WHEN utl_smtp.Transient_Error OR utl_smtp.Permanent_Error then
> > raise_application_error(-20000, 'Unable to send mail: '||sqlerrm);
> >
> > END mail_attachments_new;
> >
> > Any ideas how to fix it?
> >
> > Dont have the option of attaching a file. Otherwise, I would have
> > attached the snapshot of the error.
>
> You should use UTL_MAIL, which has an option for adding attachments. The
> procedure name is SEND_ATTACH_RAW.
>
>
>
> --
> Mladen Gogala
> The Oracle Whisperer
> http://mgogala.byethost5.com
> Je suis Charlie

Thanks. Received on Tue Jan 27 2015 - 07:21:22 CET