Send email on HP-UX Oracle server?

From: Kathy Graham <kathy_graham_at_hpl.hp.com>
Date: Tue, 06 Jul 1999 15:22:50 -0700
Message-ID: <378281BA.76A0E908@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 Tue Jul 06 1999 - 17:22:50 CDT