UTL_MAIL to Send Email form PL/SQL

Apr 2, 2014

—

in Oracle Apps, Oracle Apps Development, Oracle Apps Technical, Oracle PLSQL

Let us see how we can utilize UTL_MAIL to send Email form PL/SQL. Using the UTL_MAIL package is pretty straight forward.
Check the below example.

[sql]
begin
utl_mail.send(
sender => ‘oracle@mydomain.com’,
recipients => ‘user1@mydomain.com,user2@mydomain.com’,
subject => ‘Test Mail from my Instance’,
message => ‘Test message’
);
end;
[/sql]

As you can see there are 4 different entities that you need to consider.

Sender’s Email Id
Recipient’s Email Id – You may include one or more recipients.
Subject of the Email
Message

Let me know if you have any questions on the topic. Your feedback and suggestions are highly appreciated.

email form plsql utl_mail utl_mail.send

Comments

2 responses to “UTL_MAIL to Send Email form PL/SQL”

Sankar

December 21, 2015

Can we send attachments using utl_mail.send ?

Reply
1. ArunRaj
  
  December 23, 2015
  
  Hi Sankar,
  
  I believe you can. However you will have to give the contents for the file in the UTL_MAIL code snippet itself. You may not be able to just give the path name and expect it to be attached.
  
  What i usually do is spool the file to a directory and then use uuencode or mailx or mail (unix commands) to attach the file to the email. You can also attach file directory from the output directory using any of the above mentioned unix commands.
  
  Let me know if you have questions.
  
  Thanks,
  Arun
  
  Reply