Re: UTL_SMTP send mail wield problem????

From: Pedro Espinoza <>
Date: Thu, 26 Jun 2008 12:25:39 -0400
Message-ID: <>

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 <> wrote:
> we have ORACLE 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?

Received on Thu Jun 26 2008 - 11:25:39 CDT

Original text of this message