This sucks really bad: Can’t e-mail in a loop using UTL_SMTP!!

Ok this is weird!

I want to send e-mails to customers. I use UTL_SMTP and the Oracle supplied package demo_mail. I have renamed it to ebill2_smtp_mail.

I create subprograms to send 1 email. I test it and it works fine.

Now I want to email in a loop.

When I execute it does not work. I debugged and found out that all steps are being executed, but no-email comes to my account.

This is what I did:

v_conn := ebill2_smtp_mail.begin_session; -- Create the SMTP session

LOOP

-- I construct the e-mail here. v_conn is an IN OUT parameter.