This content has been marked as final. Show 8 replies
Sorry. UTL_SMTP does not support SSL currently (which seems to be what your SMTP server requires according to the STARTTLS message). This should be an enhancement request.
If you need to send email from the database that requires SSL, you may consider using Java stored procedure and JavaMail API instead.
Can you please answer my questions? Thanks In Advance.
1. Is UTL_SMTP able to support STARTTLS after more than 1 year has passed? If it is, how can we issue the command "STARTTLS" to the database?
2. How do Oracle Databases support STARTTLS in a general way, apart from Oracle Virtual Directory and Oracle Mail?
am following up the link
but it result in
BEGIN EXECUTE IMMEDIATE 'ALTER SESSION SET smtp_out_server = ''127.0.0.1'''; UTL_MAIL.send(sender => 'email@example.com', recipients => 'firstname.lastname@example.org', subject => 'Test Mail', message => 'Hello World', mime_type => 'text; charset=us-ascii'); END; /
so i had question by utl_mail can able to send email or not?
ERROR at line 1: ORA-29279: SMTP permanent error: 530 5.7.0 Must issue a STARTTLS command first. bj7sm12523388pab.24 ORA-06512: at "SYS.UTL_SMTP", line 21 ORA-06512: at "SYS.UTL_SMTP", line 99 ORA-06512: at "SYS.UTL_SMTP", line 222 ORA-06512: at "SYS.UTL_MAIL", line 407 ORA-06512: at "SYS.UTL_MAIL", line 594 ORA-06512: at line 3
from my1companydomainmail.com to my2comapnydomainmail.com
from gmail to mycompany domain.com