Need advice..

[at]

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

[Turkbear]

"at" <atull@worldbank.org> wrote:
I need advice on the following:We have a table in Oracle where audit information is kept. As a newrequirement, on a monthly basis we need to send an email containing thecontents of that table to users. The table have a lot of columns and Idon't think I can format nicely in the body of the email. Can anyonesuggest 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
You could use a reporting tool like Crystal Reports
to create and format a report with the needed info
and then export it to PDF or Word ( or others) format and email it in that format.

[at]

Thanks for your reply, but I need to do it within Oracle probably using
PL/SQL.

[DA Morgan]

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@x.washington.edu
(replace x with u to respond)

[Hans Forbrich]

On Fri, 21 Oct 2005 12:37:38 -0700, at interested us by writing:
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

1) Look at Oracle Discoverer. It is a tool designed for id- er, end
users. It helps make such information visible in a user friendly manner
and can be presented in an HTML page, an email or any pof a number of
other methods. It allows per-user security, drill down and graphs and
lots of pretty colours to help people click on the right spot.

It would likely be perfect for this job.

2) As an alternative, look at UTL_SMTP (which is supplied free with the
database) to mail directly from the database and the possibility of
extracting and formatting a CSV that contains all the same information as
the Discoverer output which can be imported into Excel.

That way you don't have to buy Discoverer and simply spend the same amount
of money in a custom development that you can then support on your own
forever.

3) Or make it available as a webv page using a custom developed PHP or
..Net application. Same benefit of being able to spend the money on
development and maintenance as the previous choice.

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***

[Guest]

Our organisation tends to spool output from our various databases into
various CSV files. These can then be imported into Excel, formatted
accordingly, and e-mailed as attachments to anyone who claims an
interest.

As to how useful or efficient this process is, is something only you'll
be able to answer :-)

[DA Morgan]

gareth@jamms.org wrote: Our organisation tends to spool output from our various databases into various CSV files. These can then be imported into Excel, formatted accordingly, and e-mailed as attachments to anyone who claims an interest. As to how useful or efficient this process is, is something only you'll be able to answer :-)

And if you are in the US you may safely assume that it is a direct
violation of Sarbanes-Oxley.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)