PL/SQL (MOSC)

MOSC Banner

ORA-0000: normal, successful completion on sending mail with attachment

edited Dec 13, 2010 1:25AM in PL/SQL (MOSC) 4 commentsAnswered
 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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center