sending an email with an pdf attachment using smtp command

#Sending an email with an pdf attachment using smtp command code#

UTL_SMTP.write_data(l_mail_conn, 'Content-Transfer-Encoding: base64' || UTL_TCP.crlf) UTL_SMTP.write_data(l_mail_conn, 'Content-Type: ' || p_attach_mime || ' name='' || I.FILE_NAME || ''' || UTL_TCP.crlf) UTL_SMTP.write_data(l_mail_conn, UTL_TCP.crlf || UTL_TCP.crlf) UTL_SMTP.write_data(l_mail_conn, p_text_msg) UTL_SMTP.write_data(l_mail_conn, 'Content-Type: text/plain charset='iso-8859-1'' || UTL_TCP.crlf || UTL_TCP.crlf) UTL_SMTP.write_data(l_mail_conn, '-' || l_boundary || UTL_TCP.crlf) UTL_SMTP.write_data(l_mail_conn, 'Content-Type: multipart/mixed boundary='' || l_boundary || ''' || UTL_TCP.crlf || UTL_TCP.crlf) UTL_SMTP.write_data(l_mail_conn, 'MIME-Version: 1.0' || UTL_TCP.crlf) UTL_SMTP.write_data(l_mail_conn, 'Reply-To: ' || p_from || UTL_TCP.crlf) UTL_SMTP.write_data(l_mail_conn, 'Subject: ' || p_subject || UTL_TCP.crlf) UTL_SMTP.write_data(l_mail_conn, 'From: ' || p_from || UTL_TCP.crlf) UTL_SMTP.write_data(l_mail_conn, 'To: ' || p_to || UTL_TCP.crlf) UTL_SMTP.write_data(l_mail_conn, 'Date: ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') || UTL_TCP.crlf) L_mail_conn := UTL_SMTP.open_connection(p_smtp_host, p_smtp_port) P_smtp_host VARCHAR2(100) := 'localhost' P_text_msg VARCHAR2(100):= 'This is an system generated Email' P_subject VARCHAR2(100):= 'FILE UPLOAD MAIL'

L_step PLS_INTEGER := 12000 - make sure you set a multiple of 3 not higher than 24573 I am using the following code, I changed the value of p_to and p_from

#Sending an email with an pdf attachment using smtp command code#

I am working on a PL/SQL code where I have to send mail with an attachment using UTL_SMTP. 1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition).7.9K Oracle Database Express Edition (XE).3.8K Java and JavaScript in the Database.