Thanks for the question, Rama.
Asked: February 17, 2017 - 6:12 pm UTC
Last updated: February 18, 2017 - 4:46 am UTC
Version: Oracle12c
Viewed 1000+ times
You Asked
I am not getting any error in the application when I use sender's email domain as @yahoo.com and email is not delivered to recipient. recipient will get email If I use sender's domain as @gmail.com or @abc.com or any other valid domains. So how to trap the issue if email is not delivered. Please help me.
begin
UTL_MAIL.SEND
('myid@yahoo.com',
'recipientid@gmail.com',
null,
null,
'Test',
'Testing sender email @yahoo.com',
'text/plain; charset=us-ascii',
1);
end;
with LiveSQL Test Case:
and Connor said...
Within the database, we dont do any validation as such, but many mail providers *do* have checks - to ensure that any tool (including UTL_MAIL) is not being used to generate spam etc.
For example, the ISP I use will not send out any mail via UTL_MAIL unless the sender is a valid email address within *their* email domain.
Is this answer out of date? If it is, please let us know via a Comment