Hi Tom,

I have a requirement to send email to particular domain mail id’s. But My Mail server is global mail server we can send mail to any mail ids. Is there any options in Oracle to restrict the mail send as global.
For example: My mail host is, mail.abc.com which is webmail. I have to send mail to only the mail ids which belongs abc.com.

Thanks
Tamilselvan R

procedure mail_wrapper(p_recipient varchar2, p_content varchar2, ... ) is
begin
  if lower(p_recipient) not like '%@%abc.com' then
      raise_application_error(-20000,'You can only email domain abc.com');
  end if;
  
  ...
  ... rest of normal calls to utl_smtp
  ...
end;