Hello everbody, i'm using Oracle 11g XE and the Oracle APEX 5.1 on Windows and need to send email, i tried to use UTL_MAIL package, i set on the database the cmd "/rdbms/admin/utlmail.sql" and "/rdbms/admin/prvtmail.plb" as i see in a tutorial, i create the procedure :
create or replace PROCEDURE send_mail (p_to IN VARCHAR2,
p_from IN VARCHAR2,
p_message IN VARCHAR2,
p_smtp_host IN VARCHAR2,
p_smtp_port IN NUMBER DEFAULT 25)
AS
l_mail_conn UTL_SMTP.connection;
BEGIN
l_mail_conn := UTL_SMTP.open_connection(p_smtp_host, p_smtp_port);
UTL_SMTP.helo(l_mail_conn, p_smtp_host);
UTL_SMTP.mail(l_mail_conn, p_from);
UTL_SMTP.rcpt(l_mail_conn, p_to);
UTL_SMTP.data(l_mail_conn, p_message || UTL_TCP.crlf || UTL_TCP.crlf);
UTL_SMTP.quit(l_mail_conn);
END;
/
but when i tried to send the email using the parameters that i created in the procedure i getting this error:
ORA-29278: erro transiente de SMTP: 421 Service not available
ORA-06512: em "SYS.UTL_SMTP", line 54
ORA-06512: em "SYS.UTL_SMTP", line 138
ORA-06512: em "SYS.UTL_SMTP", line 197
ORA-06512: em "SYS.SEND_MAIL", line 9
ORA-06512: em line 2
29278. 00000 - "SMTP transient error: %s"
*Cause: A SMTP transient error occurred.
*Action: Correct the error and retry the SMTP operation.
does anyone know how can i solve this?