UTL_MAIL package enables you to send and receive e-mail, along with attachments, CC, BCC, and return receipt features. : UTL_MAIL « System Packages « Oracle PL / SQL

1. Oracle PL / SQL
2. System Packages
3. UTL_MAIL

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;
/


--

 

Related examples in the same category