SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Problems with UTL_SMTP.open_connection

554432Apr 2 2012 — edited Apr 12 2012

Hi All,

I am trying to get UTL_SMTP.open_connection to work on a Oracle system which has not previously used this emailing functionality.

I managed to send out a email successfully but when I try to send out another email it fails with the error ORA-29278: SMTP transient error: 421 Service not available.

I managed to narrow the problem to the function UTL_SMTP.open_connection. For some reason it cannot make the connection the 2nd time round. I have to wait a few hours before I can send out another email.

Any ideas why this is happening?

Thanks in advance

Nahim

Locked Post

New comments cannot be posted to this locked post.

Locked on May 10 2012

Added on Apr 2 2012

14 comments

7,262 views