RE: Email from a trigger

Edward,

Try using DBMS_PIPE. It's fairly easy to stuff mail in a pipe and have an outside process listen on the pipe.

There's a generic example ( in Perl of course ) at www.cybcon.com/~jkstill/util.

Another option is to write your mail out to a file via UTL_FILE, and have a process read the directory for new mail, send it and delete the files.

Jared

On Wed, 31 Jan 2001, Sherman, Edward wrote:

> You're not alone.
> I'm trying to do this in 7.3.4.4
> If you're up to 8.1.6 you might try the stuff at
>
> http://www.iherve.com/oracle/alert_8i.htm
>
> I haven't tested any of this.
>
> Anyone doing this in 7.3?
>
> -----Original Message-----
> Subject: Email from a trigger
>
> I KNOW this has come up on the list before, and I thought I had saved it
> somewhere for if/when I would have to implement it...
>
> yet here I am, needing to implement it, and unable to find the email
>
> Anyone?
>
> Thanks.
>
> J
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).