Re: UTL_SMTP send mail wield problem????

Is it too *difficult* for you to show the script mailbody.sql?

Next, check your mail submission agent logs: grep mail /etc/syslog.conf

On my box, i see something like thus on the smtp server which your pl/sql program is connecting to.

# Log anything (except mail) of level info or higher.

*.info;mail.none;authpriv.none;cron.none                /var/log/messages
# Log all the mail messages in one place.
mail.*                                                  -/var/log/maillog

Then, check /var/log/maillog for any errors related to sending mail.

On Thu, Jun 26, 2008 at 11:56 AM, dba1 mcc <mccdba1_at_yahoo.com> wrote:
> we have ORACLE 10.2.0.4 with Redhat AS 4.4 on DELL server. Recently we are
> test "UTL_SMTP" on ORACLE PL/SQL program and tried to send MAIL to
> customers.
>
> The problem is this send MAIL program always one time work and second time
> not work (loop). I don't think problem come from ORACLE bug or any ORACLE
> relate problem. If I copy database and put on anyother server, it work
> correctly.
>
> Does anyone have suggestion?

--
http://www.freelists.org/webpage/oracle-l