send email from oracle
Posted by Arsalan on Mar 15, 2022; 12:03pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/send-email-from-oracle-tp10761.html
Hi sir ,
i want to send email from oracle to gmail i face bellow error.
Created procedure in oracle after call it to send email it give use error.
-ORACLE 12.1 db
-Oracle linux os
show parameter smtp
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
smtp_out_server string 170.1.1.1
exec utl_mail.send('gmail.com','arsaladin1khan@gmail.com','test mail','Hello World',mime_type => 'text; charset=us-ascii');SQL> SQL>
BEGIN utl_mail.send('gmail.com','arsaladin1khan@gmail.com','test mail','Hello World',mime_type => 'text; charset=us-ascii'); END;
*
ERROR at line 1:
ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at "SYS.UTL_MAIL", line 662
ORA-06512: at "SYS.UTL_MAIL", line 679
ORA-06512: at line 1