Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

UTL_MAIL package enables you to send and receive e-mail, along with attachments, CC, BCC, and return receipt features

CONNECT sys/sys_passwd @$ORACLE_HOME/rdbms/admin/utlmail.sql @$ORACLE_HOME/rdbms/admin/prvtmail.sql --define the SMTP_OUT_SERVER parameter in your init.ora initialization file --ALTER SYSTEM SET smtp_out_server='my.domain.com' SCOPE=SPFILE; BEGIN      UTL_MAIL.send(sender    => 's@n.org',                   recipients => 's@y.com',                   cc         => 's@a.com',                   bcc        => 's@h.com',                   subject    => 'Testing the UTL_MAIL Package',                   message    => 'If you get this, UTL_MAIL package                                  really works!'); END; / --