Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Send email from PL/SQL procedure

Re: Send email from PL/SQL procedure

From: Dave Drienhuizen <nldrien1_at_ey.nl>
Date: Wed, 31 May 2000 17:47:11 +0200
Message-Id: <10514.107300@fatcity.com>


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



Helmut Daiminger
gedas GmbH
Gesch=E4ftsstelle M=FCnchen
Ludwigstr. 45, D-85399 Hallbergmoos
Telefon / phone +49-811-60007-35
Telefax / fax +49-811-60007-30
Mailto:Helmut.Daiminger_at_gedas.de
http://www.gedas.de
--
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).







=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=
Received on Wed May 31 2000 - 10:47:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US