Skip to Main Content

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!

E-mail sending from PL/SQL fails with SMTP error 550 must check for new....

user12240205Apr 25 2012 — edited Apr 27 2012
We have a issue like this. We have a e-mail program (PL/SQL stored procedure which is called from a 10g R2 form) which sends e-mails using UTL_SMTP. It was working but suddenly from day-before-yesterday stopped working. Mail admin says he did not change any mail server paras.

The DB is in Linux so is the mail server. We finally did a code change. Now the mail goes to SMTP server but the mail does not go out of it (to a gmail address). We did a trace of the SMTP log and found out that it throws *550 automated@suninsurance.com.fj must check for new mail first* .

Here is the SMTP server log:
[192.168.0.6:25]

Wed 2012-04-25 18:52:46: --> 220 suninsurance.com.fj ESMTP MDaemon 12.5.4; Wed, 25 Apr 2012 18:52:46 +1200
Wed 2012-04-25 18:52:46: <-- HELO 192.168.0.6
Wed 2012-04-25 18:52:46: --> 250 suninsurance.com.fj Hello 192.168.0.6, pleased to meet you
Wed 2012-04-25 18:52:46: <-- MAIL FROM:automated@suninsurance.com.fj
Wed 2012-04-25 18:52:46: --> 250 <automated@suninsurance.com.fj>, Sender ok
Wed 2012-04-25 18:52:46: <-- RCPT TO:peter.silva@gmail.com
Wed 2012-04-25 18:52:46: --> 550 automated@suninsurance.com.fj must check for new mail first
Wed 2012-04-25 19:02:45: Connection timed out!
Wed 2012-04-25 19:02:45: SMTP session terminated (Bytes in/out: 96/256)
Wed 2012-04-25 19:02:46: ----------
Wed 2012-04-25 19:20:11: Session 17159; child 1
What could be the problem here? Any help would be greatly appreciated.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2012
Added on Apr 25 2012
10 comments
1,891 views