<

Send Email From Oracle Database

Posted on
7,582 Points
4,282 Views
3 Endorsements
Last Modified:
Published
Experience Level: Beginner
5:06
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
Author:Steve Wales
7 Comments
LVL 97

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

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

Comment

by:asif khan
Thanks for the reply.

Regards.
0

Comment

by:Anand Ghatnatti
I am getting error ORA-29279: SMTP permanent error: 504 auth type not available (#5.5.1) please help. I am using Oracle 11g R1
0
LVL 23

Author Comment

by:Steve Wales
This sort of thing is probably better directed as a separate question rather than a comment on the video (you'll hit a wider audience than just me (or anyone else who has commented on the video).

Most likely candidate in my mind is that your relay server isn't set up to accept incoming relay requests from your database server.  But, again, I'd post this as a separate question with more detail than just the error message you're getting.
0
In this article, we will see how we can automate the process of moving Oracle metadata to version control system, in my case I am using GIT using a simple shell script to avoid manual intervention.
In this article, we'll create a simple PL/SQL block to identify potential performance problem for given SQL statement.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month