CODEWITHSUNDEEP
oracle-databasesmtporacle11g
Bishan
Bishan

Reputation: 15740

Issue with UTL_MAIL Oracle

I'm trying to send email using oracle 11g as below.

begin
  utl_mail.send(
  sender     => '[email protected]',
  recipients => '[email protected]',
  message    => 'Hello World'
  );

but i got below error.

ORA-29279: SMTP permanent error: 530 5.5.1 http://support.google.com/mail/bin/answer.py?answer=14257 ph1sm17301835pbb.45
ORA-06512: at "SYS.UTL_MAIL", line 654
ORA-06512: at "SYS.UTL_MAIL", line 671
ORA-06512: at line 2
29279. 00000 -  "SMTP permanent error: %s"
*Cause:    A SMTP permanent error occurred.
*Action:   Correct the error and retry the SMTP operation.

how could i solve this ?

Upvotes: 0

Views: 1668

Answers (1)

Frank Schmitt
Frank Schmitt

Reputation: 30835

According to the GMail documentation, you need SMTP/Auth to send E-Mails via GMail.

Unfortunately, utl_mail doesn't support this - you'll have to use utl_smtp.

See Oracle Forums for an example.

Upvotes: 3

Related Questions