<

Learn how to a build a cloud-first strategyRegister Now

x

Send Email From Oracle Database

Posted on
4,656 Points
1,356 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 78

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 23

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 23

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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Suggested Courses
Course of the Month20 days, 19 hours left to enroll

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month