Home » SQL & PL/SQL » SQL & PL/SQL » sending a mail with Oracle
sending a mail with Oracle [message #38781] Tue, 14 May 2002 09:53 Go to next message
mousie
Messages: 9
Registered: March 2002
Junior Member
Hello;

Can someone tell me if it is possible to send a mail from oracle 7.3 (within a PL/SQL proc for ex) ?
Thank you very much

Report message to a moderator

Re: sending a mail with Oracle [message #38783 is a reply to message #38781] Tue, 14 May 2002 13:01 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
You can but it's not straightforward.
1.) set up the ability to run an external command from pl/sql on the server:
2.) use utl_file to write your email to a temp file (unless it's a short email)
3.) call mailx or similar mail program on the server to send the email.
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:16212348050

Report message to a moderator

Previous Topic: Re: generating sequence/primary key based on dept (a column)type
Next Topic: PL/SQL function returning table OR parameterized view
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 17:10:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.