Xref: alice comp.databases.oracle.misc:43862 Path: alice!news-feed.fnsi.net!feed.newsfeeds.com!newsfeeds.com!newsfeed.berkeley.edu!dispose.news.demon.net!demon!diablo.theplanet.net!news.theplanet.net!newspost.theplanet.net!not-for-mail From: Connor McDonald Newsgroups: comp.databases.oracle.misc Subject: Re: Send mail from SP Date: Sun, 10 Oct 1999 14:00:34 +0800 Organization: Customer of Planet Online Message-ID: <38002B82.6D3C@yahoo.com> References: <8jPL3.70768$L6.7841231@news1.rdc1.on.wave.home.com> Reply-To: connor_mcdonald@yahoo.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: news5.svr.pol.co.uk 939560107 25648 62.136.197.164 (10 Oct 1999 12:55:07 GMT) NNTP-Posting-Date: 10 Oct 1999 12:55:07 GMT X-Complaints-To: abuse@theplanet.net X-Mailer: Mozilla 3.01 (Win95; I) To: marasoft Lines: 23 marasoft wrote: > > Does anyone know if it is possible to send an email message from a stored > procedure (PL/SQL)? Is there any package that can do this? > > Thank's > David For Version 8+ you can use an external procedure to set this up... In versions below this, PLEX is a very useful utility to allow operating system commands from the database (email included)... Try http://osi.oracle.com/~tkyte HTH -- =========================================== Connor McDonald "These views mine, no-one elses etc etc" connor_mcdonald@yahoo.com "Some days you're the pigeon, and some days you're the statue."