Re: UTL_SMTP send mail wield problem????
- From: "Pedro Espinoza" <raindoctor@xxxxxxxxx>
- To: mccdba1@xxxxxxxxx
- Date: Thu, 26 Jun 2008 12:25:39 -0400
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@xxxxxxxxx> 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?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
