Re: Email From withing PL/SQL
From: <bonanos_at_yahoo.com>
Date: 1998/07/17
Message-ID: <6omqp7$tb3$1_at_nnrp1.dejanews.com>#1/1
?>
Date: 1998/07/17
Message-ID: <6omqp7$tb3$1_at_nnrp1.dejanews.com>#1/1
Hi Samuel
> Has anyone, or does anyone know how, to send an email from with in PL/SQL
> code?
What you have to do is call a third party function that will do the mailing for you.
You can use DBMS_PIPE.
Or you can have something like the apache web server installed on your system and have a php3 script that does the mailing for you:
- <TITLE>Sendmail Response</TITLE> </HEAD> <BODY bgcolor=#FFFFFF>
<h2>Sending mail using PHP3</h2>
<?
echo("<i>To:</i> $To"); echo("<p><i>Subject:</i> $Subject"); echo("<p><i>Message:</i> $Message"); mail($To,$Subject,$Message);
?>
<hr>
<?
echo("<p> The message was sent to <b> $To </b>");
?>
</BODY> </HTML>
-- If you also had the oracle webserver with the the pl/squeel cartridge installed you would write a pl/sql procedure that would call the above url. -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member ForumReceived on Fri Jul 17 1998 - 00:00:00 CEST