Home » SQL & PL/SQL » SQL & PL/SQL » How can send e-mail using a Trigger?
How can send e-mail using a Trigger? [message #36067] Fri, 02 November 2001 05:34 Go to next message
Simiyu
Messages: 2
Registered: November 2001
Junior Member
How can I send e-mail using a PL/SQL (Trigger) in oracle 8i runnding on windows 2000?.

----------------------------------------------------------------------
Re: How can send e-mail using a Trigger? [message #36101 is a reply to message #36067] Mon, 05 November 2001 11:10 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
yes you can. It's easier to do in 8.1.5 or later using UTL_SMTP. In earlier versions it could be done with a bit more trouble using dbms_pipe.
http://www.revealnet.com/Pipelines/PLSQL/archives.htm#news18

Of course you need some mail program installed on your machine too.

----------------------------------------------------------------------
Re: How can send e-mail using a Trigger? [message #36517 is a reply to message #36101] Sun, 02 December 2001 22:20 Go to previous message
kueng
Messages: 1
Registered: December 2001
Junior Member
Is the only method on sending email on earlier Oracle version by using daemon and PL/SQL ?

----------------------------------------------------------------------
Previous Topic: Commit
Next Topic: Re: how use the if condition to check inputs in pl sql
Goto Forum:
  


Current Time: Tue Mar 31 06:10:01 CDT 2020