Re: How can I automatically send an email

From: Gerrit-Jan Linker <gjlinker_at_litconsulting.freeserve.co.uk>
Date: Sun, 4 Apr 1999 22:26:35 +0100
Message-ID: <7eaehl$lvs$1@news7.svr.pol.co.uk>

Dear all,

>Joep, For sending email from Oracle8, you need to write an external
procedure
>and then use dbms_alert to trigger it automatically.

Please be careful with this. dbms_alert may get you in all sorts of unwanted locking trouble. I think the use of dbms_pipe is preferrable in this case to get info from one DB session into another. This package does not have any locking problems.

Regards, Gerrit-Jan Linker
Developer of Oraxcel, OraDebug, OraCodes and OraSQL http://members.aol.com/gjlinker Received on Sun Apr 04 1999 - 16:26:35 CDT