<

Send Email From Oracle Database

Posted on
4,249 Points
952 Views
3 Endorsements
Last Modified:
Experience Level: Beginner
5:08
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
3
Comment
Author:Steve Wales
  • 2
  • 2
5 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
For the UTL_MAIL section, make it OS generic (even the docs don't).

Instead of this for Windows:
@%ORACLE_HOME%/rdbms/admin/utlmail.sql
@%ORACLE_HOME%/rdbms/admin/prvtmail.plb

For UNIX flavors:
@$ORACLE_HOME/rdbms/admin/utlmail.sql
@$ORACLE_HOME/rdbms/admin/prvtmail.plb

Use the LONG forgotten sqlplus shortcut for ORACLE_HOME:
@?/rdbms/admin/utlmail.sql
@?/rdbms/admin/prvtmail.plb

Works across platforms and if used in scripts, no modifications necessary.
0
 
LVL 22

Author Comment

by:Steve Wales
An excellent point I hadn't even considered when making the video.  Thanks for the note!
0
 

Expert Comment

by:asif khan
Hi,
Sir, can we use smtp.gmail.com as a email server.

Regards,
0
 
LVL 22

Author Comment

by:Steve Wales
I see no reason why you can't - as long as you have an existing set up where you can use it, any valid email relay you have permissions to use should work
0
 

Expert Comment

by:asif khan
Thanks for the reply.

Regards.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Join & Write a Comment

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month