I'm using Oracle 8i and trying to send an automated email using Oracle's UTL_SMTP utility. I'm attempting to connect to and send authentication to a Network Solutions email server.
l_mail_conn := UTL_SMTP.open_connection(p_smtp_host, p_smtp_port);
UTL_SMTP.data(l_mail_conn, p_message || UTL_TCP.crlf || UTL_TCP.crlf);
I've checked with Network Solutions and my hostname and port are correct. The username and password I'm sending are also correct and they claim sending them as a simple character string is also okay.
I seem to be connecting to the email server properly but I get an error message:
ORA-20002: 535 authentication failed (#5.7.1)
ORA-06512: at "SYS.UTL_SMTP", line 86
ORA-06512: at "SYS.UTL_SMTP", line 141
...plus line references to my procedure...
What am I doing wrong?