Oracle Database - utl_mail package

About

How to send a mail with the PL/SQL utl_mail package.

Steps

Prerequisites

sqlplus sys/<pwd>
SQL> @$ORACLE_HOME/rdbms/admin/utlmail.sql
SQL> @$ORACLE_HOME/rdbms/admin/prvtmail.plb
ult_mail package is created

To send a mail

UTL_MAIL.SEND (
sender =>'mail.id',
recipients =>'mail.id',
cc =>'mail.id',
subject='subject'
message =>'msg')

Powered by ComboStrap