Re: Send email on HP-UX Oracle server?

Hello Kathy,

  We have tried out sending mails from the Oracle database   8.0.4 from HP-UX server. It was successful

  I can try giving you the overall picture of how it works -

1. A daemon program listed in the Oracle Developers Guide - daemon.pc should be listening continuously on the HP server on a particular DBMS_PIPE.
2. Oracle trigger should write the contents of the mail into a particular file, say /mnt/xxx/file.txt And the trigger should write the foll into the pipe using the dbms_pipe() utility as - mail /mnt/xxx/file.txt
3. Once a message is queued in the pipe, daemon which is listening should execute dbms_pipe.receive_message() to receive message. Once this is done, the daemon will execute the message as a command on UNIX. From here on, UNIX will send mail to the users.

      Note : Configuring UNIX is done in /etc/mail/sendmail.cf
                daemon.pc program is already present in Oracle Developers
Guide book.
                Only pending thing from your side is trigger coding.

Best of Luck,
Vinod.

Kathy Graham <kathy_graham_at_hpl.hp.com> wrote in article <378281BA.76A0E908_at_hpl.hp.com>...
> Hi Folks;
> I need to be able to send e-mail that is fired off via a trigger. I
>
> have found an example in the Oracle PL/SQL programming book (Feuerstein)
>
> that uses the UNIX mail-x package. It involves some C functions that
> call the OCI library. Theoretically, once it is linked and compiled, I
> should be able to send mail from my PL/SQL code.
>
> Also, I found some references to using DBMS_PIPE for similar
> functionality. A few questions:
>
> - 1) Has anyone else done mail with the above configuration, and before
> I start trying to following this up, have a better alternative to offer?
>
> - 2) The example was tested using Oracle 8.0.3 and Solaris 2.5.1. Has
> anyone used this example and/or moved it over to HP-UX? Comments?
>
> Thanks in advance for your assistance.
>
>
> Kathy Graham
> I.T. Engineer/ Engineering Operations/HP Labs
> Telnet 236-2422
> kathy_graham_at_nomail.hpl.hp.com
>
>
>
>
Received on Thu Jul 08 1999 - 01:07:14 CDT