RE: Oracle 8.1.6, Solaris, and e-mail

I lately posted an inquiry for sending E-Mails in Oracle and the only reply I got was for 8.1.6 and above to use UTL_SMTP package.

Since I had to deal with 8.0.5 I had to find an alternate solution. You can writes up text files using UTL_FILE for every change that needs to send the E-Mail. Run a batch job to poll for these messages(text files) and kicks off E-mail of these text files Removes/save these files into another location.

	EShevtsov_at_flagship.ru
	11/17/00 02:37 PM
		 
		 To: ORACLE-L_at_fatcity.com_at_SMTP
		 cc: (bcc: Cindy P Nathan/SWF/Pharma)
		 Subject: RE: Oracle 8.1.6, Solaris, and e-mail

Hi,

the package is available under 8.1.6. Also you can have an option to use external procedures, you need write a .dll or .so which will be support of email sending

Regards,
Ed  

>
>
> The only documentation that I have handy is for 8.0.5 and
> doesn't include
> that package. Do you know anywhere where an example of the
> use of this
> package is available?
>
> Thanks
>
> -----Original Message-----
> Sent: Friday, November 17, 2000 9:51 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Use the Oracle supplied UTL_SMTP package
>
> "Day, Tom" wrote:
> >
> > Does anybody know how to have Oracle automatically fire
> off an e-mail when
> a
> > particular table is updated?
> >
> > I seem to remember a discussion from some time ago about
> DBA's who had set
> > up remote Oracle databases that would fire off an e-mail
> when certain
> > problems arouse, but I didn't save any particulars.
> >
> > Thanks
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Day, Tom
> > INET: tday_at_grci.com
> >
> > 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).
>
> --
> Charlie Mengler Maintenance Warehouse
> charliem_at_mwh.com 10641 Scripps Summit Ct
> 858-831-2229 San Diego, CA 92131
> You don't know what you don't know. Think about it.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Charlie Mengler
> INET: charliem_at_mwh.com
>
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Day, Tom
> INET: tday_at_grci.com
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shevtsov, Eduard
  INET: EShevtsov_at_flagship.ru

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).



------------------------------

 From: Jared Still <jkstill_at_bcbso.com>
 Date: Fri, 17 Nov 2000 12:02:20 -0800 (PST)
 Subject: Re: interesting ...

On Fri, 17 Nov 2000, bunyamin karadeniz wrote:

> PROCEDURE den1 (a IN number) as
> b number;=20
> begin=20


>     b :=3D a;=20

>     dbms_output.put_line(b*5);

> end;
>=20


>  ACCEPT datehired DATE FORMAT 'dd/mm/yy' DEFAULT '11/11/1111' PROMPT 'ent=

er the date:' ;
> I enter 11/12/99 when asks me to enter the date .
>=20
> And then I  executed the den1 procedure by passing the datehired paramete=
r (which is date ) by=20


>  EXEC den1(&datehired);=20

>=20
> And did not give an error although it had shown that ( when =FD wrote def=
ine) it is a char parameter and I wanted to pass a char to a number ..
>=20
> Result is interesting .