My Oracle Support Banner

How to Send an Email Using UTL_SMTP with Authenticated Mail Server. (Doc ID 885522.1)

Last updated on JULY 19, 2018

Applies to:

PL/SQL - Version 9.2.0.1 to 12.1.0.1 [Release 9.2 to 12.1]
Information in this document applies to any platform.
*** Checked for relevance on 19-Jul-2018 ***

Goal

The UTL_SMTP package is designed for sending electronic mail (E-Mail) over simple mail transfer protocol (SMTP) as specified by RFC821. Some mail servers require username and password to be supplied for authentication. If the username and password is not supplied when the SMTP server expects it, then call to the UTL_SMTP will fail with "ORA-29279: SMTP permanent error: 530 Authentication required".

The sample code below shows how to include the username/password for the mail server.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.