CODEWITHSUNDEEP
oracle-databaseplsqloracle11g
Sachin Gupta
Sachin Gupta

Reputation: 41

SMTP error while I am trying to run the sending email program in oracle pl/sql

When I am running this, i am getting error:

begin
UTL_MAIL.SEND(SENDER =>'[email protected]',
RECIPIENTS=> '[email protected]',
SUBJECT=> 'MAIL FROM dbaclasss SENDER',
MESSAGE => 'Welcome to dbaclass'
);
end;

Error:

Error report -
ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at "SYS.UTL_MAIL", line 654
ORA-06512: at "SYS.UTL_MAIL", line 671
ORA-06512: at line 2
29278. 00000 -  "SMTP transient error: %s"

I checked the telnet command to check the stmp.gmail.com its working fine. but when i tried this from oracle it is giving the above error.

Can someone please help me.

Upvotes: 0

Views: 3529

Answers (1)

jareeq
jareeq

Reputation: 451

That will not work out of the box.

If your server is not ssl/tls you need at least set (maybe create local smtp first for test) and set acl:

ALTER SYSTEM SET smtp_out_server = 'mailserver.domain.com'

If server is secure (and gmail is) and you have no local smtp server to work with. You need to do more to set secure connection. Look at this to get idea for start(you need walled or own secure ssl/tls implementation):

Probably at this too:

Upvotes: 0

Related Questions