Re: Duhvelopers and DB-ehs?

Hi,

take a look at the UTL_SMTP package.

| Regards,                   |
| Stefan Jahnke              |
| BOV AG                     |
| @:D2 Vodafone, Abt.: FBOM  |
| Tel.: 0211/533-4893        |
 ----------------------------

"Thomas, Kevin" schrieb:
>
> OOooh, that's something I want to be able to do is to send email to us
> in case of problems...I can send email from OraForms using Outlook but
> I've not got round to checking out how I send email from a Unix box
> via pl/sql or the likes....any suggestions?
>
> K.
>
> "hit any user to continue"
> __________________
>
> Kevin Thomas
> Technical Analyst
> Deregulation Services
> Calanais Ltd.
> (2nd Floor East - Weirs Building)
> Tel: 0141 568 2377
> Fax: 0141 568 2366
> http://www.calanais.com
>
> -----Original Message-----
> Sent: 31 August 2001 17:38
> To: Multiple recipients of list ORACLE-L
>
> we have homegrown shell scripts -- page us, email us, send daily status of=
> t
> he world reports... works!
>
> >From: "Thomas, Kevin" <Kevin.Thomas_at_calanais.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: RE: Duhvelopers and DB-ehs?
> >Date: Fri, 31 Aug 2001 05:47:12 -0800
> >
> >Database monitoring tools....thrrp! We wrote our own using Java and lots of
> >SQL are shell scripts...patchy but it works ;-)
> >
> >
> >__________________
> >
> >Kevin Thomas
> >Technical Analyst
> >Deregulation Services
> >Calanais Ltd.
> >(2nd Floor East - Weirs Building)
> >Tel: 0141 568 2377
> >Fax: 0141 568 2366
> >http://www.calanais.com
> >
> >
> >-----Original Message-----
> >Sent: 31 August 2001 14:17
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >I've got 11 databases (and just found out I'll probably have a new one, a
> >semi, sort of, kind of data warehouse -- I need those books!)
> >
> >and there is me, my junior DBA who is not so junior anymore, and one
> >consultant.
> >
> >And my CTO thinks that the DBAs are really just extra programming=20
> >resources.
> >
> >So half the time we are doing non-DBA work.
> >
> >Oh yeah, and we don't have any of those high-falutin' database monitoring
> >tools either :)
> >
> >
> > >From: Robertson Lee - lerobe <lerobe_at_acxiom.co.uk>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >Subject: RE: Duhvelopers and DB-ehs?
> > >Date: Fri, 31 Aug 2001 02:55:26 -0800
> > >
> > >Bloody Hell, we have half that amount of systems yet only two DBAs. What=
> >
> on
> > >earth do they do with the rest of their time.
> > >
> > >
> > >-----Original Message-----
> > >Sent: 31 August 2001 09:40
> > >To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >LOL...with 31 systems to support 24/7/365 if you threw a stone in any
> > >direction you would hit a DBA. At the last count I believe we had 12...!!
> > >
> > >
> > >__________________
> > >
> > >Kevin Thomas
> > >Technical Analyst
> > >Deregulation Services
> > >Calanais Ltd.
> > >(2nd Floor East - Weirs Building)
> > >Tel: 0141 568 2377
> > >Fax: 0141 568 2366
> > >http://www.calanais.com
> > >
> > >
> > >-----Original Message-----
> > >Sent: 30 August 2001 17:22
> > >To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >Sounds like your company is looking for a new DBA? :-))))
> > >
> > >Jan Pruner
> > >
> > >Dne ?t 30. srpen 2001 17:26 jste napsal(a):
> > > > I have to say I resent being called a duhveloper, granted the majority
> > > > couldn't tune a banjo let alone tune a piece of SQL, but as a techie
> > >(and
> > > > we all are), I find this list invaluable for getting advice on a wide
> > >range
> > > > of topics, not just keeping a DB up and running or tuned...I don't=20
> >call
> > >you
> > > > guys names, and let's face it you DB-ehs? couldn't write a decent
> > > > application if your lives depended on it...
> > > >
> > > > (blue touch-paper lit, retire a distance, do not re-approach once lit,
> > >and
> > > > wait for fireworks)
> > > >
> > > >
> > > > "hit any user to continue"
> > > > __________________
> > > >
> > > > Kevin Thomas
> > > > Technical Analyst
> > > > Deregulation Services
> > > > Calanais Ltd.
> > > > (2nd Floor East - Weirs Building)
> > > > Tel: 0141 568 2377
> > > > Fax: 0141 568 2366
> > > > http://www.calanais.com
> > > >
> > > >
> > > > -----Original Message-----
> > > > Sent: 30 August 2001 15:46
> > > > To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > >
> > > > no, those posts keep us "underworked" DBAs from killing the=20
> >duhvelopers
> > >who
> > > > make us do the same thing over and over and over and who never listen
> > >when
> > > > we tell them the correct way to design the tables.
> > > >
> > > > :)
> > > >
> > > > From: "Boivin, Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca>
> > > >
> > > > >Reply-To: ORACLE-L_at_fatcity.com
> > > > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > > >Subject: RE: !! Keeping the list alive
> > > > >Date: Thu, 30 Aug 2001 04:00:52 -0800
> > > > >
> > > > >Just look at the number of OT postings in the last couple of=20
> >months...
> > > > >
> > > > >: )
> > > > >
> > > > >Patrice Boivin
> > > > >Systems Analyst (Oracle Certified DBA)
> > > > >
> > > > >Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
> > > > >Technology Services | Services technologiques
> > > > >Informatics Branch | Direction de l'informatique
> > > > >Maritimes Region, DFO | R=E9gion des Maritimes, MPO
> > > > >
> > > > >E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>
> > > > >
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > From: schmoldt_at_fyiowa.com [SMTP:schmoldt_at_fyiowa.com]
> > > > > Sent: Wednesday, August 29, 2001 7:58 PM
> > > > > To: Multiple recipients of list ORACLE-L
> > > > > Subject: RE: !! Keeping the list alive
> > > > >
> > > > > You're surprised at those willing to pay?
> > > > >
> > > > > You have to realize that most DBAs are over-payed and under-worked
> > > > >....
> > > > > <<ducking>>
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com]
> > > > > > Sent: Wednesday, August 29, 2001 1:43 PM
> > > > > > To: Multiple recipients of list ORACLE-L
> > > > > > Subject: !! Keeping the list alive
> > > > > >
> > > > > >
> > > > > >
> > > > > > This list is apparently a more valuable resource to many of you
> > > > >
> > > > >than I
> > > > >
> > > > > > realized.
> > > > > >
> > > > > > I'm literally bowled over by the generosity. I've received
> > > > > > so many emails
> > > > > > about
> > > > > > this that I really can't personally reply to them all right now.
> > > > >
> > > > > --
> > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > > --
> > > > > Author:
> > > > > INET: schmoldt_at_fyiowa.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: Boivin, Patrice J
> > > > > INET: BoivinP_at_mar.dfo-mpo.gc.ca
> > > > >
> > > > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > > >San Diego, California -- Public Internet access / Mailing=20
> >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).
> > > >
> > > > _________________________________________________________________
> > > > Get your FREE download of MSN Explorer at
> > >http://explorer.msn.com/intl.asp
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Jan Pruner
> > > INET: jan_at_pruner.cz
> > >
> > >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: Thomas, Kevin
> > > INET: Kevin.Thomas_at_calanais.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).
> > >
> > >
> > >The information contained in this communication is
> > >confidential, is intended only for the use of the recipient
> > >named above, and may be legally privileged. If the reader
> > >of this message is not the intended recipient, you are
> > >hereby notified that any dissemination, distribution or
> > >copying of this communication is strictly prohibited.
> > >If you have received this communication in error, please
> > >re-send this communication to the sender and delete the
> > >original message or any copy of it from your computer
> > >system.
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Robertson Lee - lerobe
> > > INET: lerobe_at_acxiom.co.uk
> > >
> > >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).
> >
> >
> >_________________________________________________________________
> >Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Rachel Carmichael
> > INET: carmichr_at_hotmail.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: Thomas, Kevin
> > INET: Kevin.Thomas_at_calanais.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).
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: Rachel Carmichael
> INET: carmichr_at_hotmail.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).
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: Thomas, Kevin
> INET: Kevin.Thomas_at_calanais.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).
>
> ---------------------------------------------------------
> This Mail has been checked for Viruses
> Attention: Encrypted mails can NOT be checked!
>
> **
>
> Diese Mail wurde auf Viren geprueft
> Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden!
> ---------------------------------------------------------

--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stefan Jahnke
  INET: stefan.jahnke_at_d2vodafone.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).