Fwd: RE: Mailing frm Oracle

From: Paul Drake <drake_at_psscorp.com>
Date: Thu, 22 Feb 2001 18:26:15 -0800
Message-ID: <F001.002BB4C7.20010222181111@fatcity.com>

one caution:

If you're using Oracle 8.1.x on NT (NT4 - W2K) you will have some serious issues with killing dba_jobs. okay - its very easy to kill a dbms_job. shutdown abort takes care of it - no problem. I had a dbms_job emptying a mail queue that opened 3976 connections to a Sendmail server last night - it stopped at port 4999 (testing code). The mail server didn't even blink.

I could not kill a dbms_job - as it deferred the kill session. 7.3 use to have a parameter that allowed you to not keep the connection alive.
That parameter isn't available in 8.1.6.

So once again, less ways to get at the OS - less ways to maintain processes. If you actually have users that don't want to have their instance shutdown, better test that code very well ...

Paul

• Original Message -------- Date: Thu, 22 Feb 2001 14:40:27 -0800 Reply-To: ORACLE-L_at_fatcity.com Organization: Fat City Network Services, San Diego, California To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

On 8.1.6+ you can use UTL_SMTP.
Vadim Gorbounov
Oracle DBA

-----Original Message-----
Sent: Thursday, February 22, 2001 3:11 PM To: Multiple recipients of list ORACLE-L

Hi Everybody,

I wanted to forward a mail to a particular Id thru an Oracle Procedure , can anybody tell me whether I can do that thru an Oralce Procedure if so pls inform how to do the same.

I dont want to mail to a Unix Login id , I want to mail to a mail server

For e-g test_at_hotmail.com

Thanks In Advance,

Shankar Swamy.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Shankar Shanmugaswamy
  INET: sshankar_at_lason.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: Vadim Gorbounov
  INET: vgorbounov_at_simplyengineering.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: Paul Drake
  INET: drake_at_psscorp.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). Received on Thu Feb 22 2001 - 20:26:15 CST