Database Utilities (MOSC)

MOSC Banner

Problem with sending mail from Oracle 9.2

edited Sep 19, 2017 5:03AM in Database Utilities (MOSC) 3 commentsAnswered

Hello

I have problem with sending mail from some mailhosts. The procedure is working fine on most hosts, but here is example when it's not working. The output is: PL/SQL procedure successfully completed, but mail is not sent.

This is the procedure:

declare

  msg_to varchar2(100) := 'ante.despalaatovic@pos-st.hr';

  msg_subject varchar2(100) := 'subject';

  msg_text varchar2(100) := 'text';

  c utl_smtp.connection;

  rc integer;

  msg_from varchar2(50) := 'ante.despalatovic@vip.hr';

  mailhost VARCHAR2(30) := 'mail.vip.hr';

BEGIN

  c := utl_smtp.open_connection(mailhost, 25); -- SMTP on port 25

  utl_smtp.helo(c, mailhost);

  utl_smtp.mail(c, msg_from);

  utl_smtp.rcpt(c, msg_to);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center