Oracle Database - utl_mail package

Card Puncher Data Processing

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')







Share this page:
Follow us:
Task Runner