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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Formatting output using utl_smtp?

Re: Formatting output using utl_smtp?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 03 Aug 2006 07:50:31 +0200
Message-ID: <8j33d25de0ph805k93r80so0ga1253goss@4ax.com>


On 2 Aug 2006 17:36:54 -0700, stacyfrances_at_gmail.com wrote:

>Hi,
>
>I've generated an email using the utl_smtp.write_data function on
>Oracle 9i. Is it possible to format the data a bit...mainly to center
>it?
>
>I am trying to generate data similar to this format:
>
>ID Name Action
>----------------------------------
>123 Stacy Update
>23445 Brian Add
>
>Each of these items are retrieved through a cursor. Any ideas?

utl_smtp sends mail. It just does that. Nothing more. Could you send it in html format and use the htp.print interface to add tags?

--
Sybrand Bakker, Senior Oracle DBA
Received on Thu Aug 03 2006 - 00:50:31 CDT

Original text of this message

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