Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Send email from PL/SQL procedure
Well, I didn't follow the old thread but if I'm correct, DBMS_MAIL can =
only be
used if you
install Oracle Office. Don't know if you have it installed ( I wonder =
if it's
still used).
However, you can check out this link :
http://members.xoom.com/hakan_yuksel/htmls/utilities.htm
There is some example code there that shows you how to e-mail from with=
in a
PL/SQL
procedure, especially on Windows NT.
"Daiminger, Helmut" <Helmut.Daiminger_at_gedas.de>@fatcity.com on 31-05-20=
00
14:55:51
Please respond to ORACLE-L_at_fatcity.com
Sent by: root_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: Send email from PL/SQL procedure
Hi!
Sorry for asking this question again, but I deleted the old thread...
How do I send an email from within a PL/SQL procedure? I think it is by=
using the dbms_mail package, right?
How do I create this package? What's the script file's name?
Is this also availabale on 8.0.5 (on NT) or is it an 8.1.x feature?
Thanks,
Helmut
-- Author: Daiminger, Helmut INET: Helmut.Daiminger_at_gedas.de Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed May 31 2000 - 10:47:11 CDT
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
De informatie verzonden met dit E-mail bericht is uitsluitend bestemd v= oor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreid= ing en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging va= n de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
The information contained in this communication is confidential and may= be legally privileged. It is intended solely for the use of the individual= or entity to whom it is addressed and others authorised to receive it. If = you are not the intended recipient you are hereby notified that any disclos= ure, copying, distribution or taking any action in reliance on the contents= of this information is strictly prohibited and may be unlawful. Ernst & Young is neither liable for the proper and complete transmission of th= e information contained in this communication nor for any delay in its receipt.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
![]() |
![]() |