Re: Need advice..

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 21 Oct 2005 14:08:14 -0700
Message-ID: <1129928892.451417_at_yasure>


at wrote:
> I need advice on the following:
>
> We have a table in Oracle where audit information is kept. As a new
> requirement, on a monthly basis we need to send an email containing the
> contents of that table to users. The table have a lot of columns and I
> don't think I can format nicely in the body of the email. Can anyone
> suggest what is the best way to approach this (HTML,XML,CSV)? Also,
> once the report is generated, i would like to store in a table.
>
> Thanks,
> AT

And the version of Oracle is?

If 10g use UTL_MAIL and attach is to the email.

You provided no information on the number of columns, whether all are required, their size, etc. I'm surprised someone didn't just tell you to use a very small font.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Oct 21 2005 - 23:08:14 CEST

Original text of this message