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

Home -> Community -> Usenet -> c.d.o.server -> Re: Sending mail from Oracle On Solaris

Re: Sending mail from Oracle On Solaris

From: Ralph Graulich <ralph_at_grauli.ch>
Date: Tue, 05 Mar 2002 18:08:25 +0100
Message-ID: <ralph-054677.18082505032002@doorway.ih.reiff.de>


Hi Yann,

> I'm not so familiar with Unix.

No problem.

> What do you mean by "Pipe the header and body of the mail to stdin of this
> program " ?
> Could you provide an example ?

Sure. You may consult "man mail" on your unix machine to get a manual page for your specific mail command's options.

On my system for example, I can issue:

echo "Hello, this is some silly test message" | mail -s "Silly test" myadress_at_email.com

Which means, writing "Hello, this is some silly test message" in the message body and sending the message to "myadress_at_email.com", including the subject "Silly test".

So, if you get some output of e.g. SQL*Plus, you can "pipe" ( "|" is called pipe sign) the output directly to "mail", which handles the procedure of building and sending the mail to your local MTA (mail transfer agent).

Regards
... Ralph ... Received on Tue Mar 05 2002 - 11:08:25 CST

Original text of this message

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