OraFAQ Forum: SQL & PL/SQL » How can send e-mail using a Trigger?

Home » SQL & PL/SQL » SQL & PL/SQL » How can send e-mail using a Trigger?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can send e-mail using a Trigger? [message #36067]

Fri, 02 November 2001 05:34

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?.

----------------------------------------------------------------------

Report message to a moderator

Re: How can send e-mail using a Trigger? [message #36101 is a reply to message #36067]

Mon, 05 November 2001 11:10

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.

----------------------------------------------------------------------

Report message to a moderator

Re: How can send e-mail using a Trigger? [message #36517 is a reply to message #36101]

Sun, 02 December 2001 22:20

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 ?

----------------------------------------------------------------------

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Oct 04 21:13:36 CDT 2023