Re: UTL_SMTP send mail wield problem????
Date: Thu, 26 Jun 2008 12:25:39 -0400
Message-ID: <b86c876f0806260925x25d5ad49hef058930304fdbcb@mail.gmail.com>
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-lReceived on Thu Jun 26 2008 - 11:25:39 CDT