ORA-0000: normal, successful completion on sending mail with attachment
Dear all,
I have a PL/SQL procedure to send email with attachment to a recipient.
IF n_filesize > 0 THEN
SELECT ftfile INTO b_file_att FROM T_FILE_TRANSFER WHERE ftuser='CEK_TOKO_FULL_DATA';
n_dummy := Send (
p_from => 'albert@indomaret.co.id',
p_to => c_email,
p_cc => NULL,
p_bcc => NULL,
p_subject => 'List Toko Belum Kirim RRAK di SLP (text file) untuk DC '||c_gudang,
p_body => 'Terlampir File List Data SLP (text file) Toko Yang Belum Ada Data RRAK, tolong dilengkapi karena akan digunakan untuk performance toko',
p_smtp_host => c_smtpdb,
p_attachment_data => b_file_att,
I have a PL/SQL procedure to send email with attachment to a recipient.
IF n_filesize > 0 THEN
SELECT ftfile INTO b_file_att FROM T_FILE_TRANSFER WHERE ftuser='CEK_TOKO_FULL_DATA';
n_dummy := Send (
p_from => 'albert@indomaret.co.id',
p_to => c_email,
p_cc => NULL,
p_bcc => NULL,
p_subject => 'List Toko Belum Kirim RRAK di SLP (text file) untuk DC '||c_gudang,
p_body => 'Terlampir File List Data SLP (text file) Toko Yang Belum Ada Data RRAK, tolong dilengkapi karena akan digunakan untuk performance toko',
p_smtp_host => c_smtpdb,
p_attachment_data => b_file_att,
0