Re: Oracle and e-mail

Ken -

At my work place we have existing systems that work in a VAX / VMS environment taking output produced from an ORACLE database - a list file - that can then be automatically mailed (internally) via CC:Mail.

The method used is to have a controlling command file that handles the output process. In our case it is written in DCL, but the same functionality could be written in any OS. An exception report could be produced off the end of this processing.

Does this help? I can't really help further without more information. If you do require further help, please email me.

Good luck anyway!

Martyn Cavett
cavett_at_globalnet.co.uk  

Ken Harris <kcharris_at_flash.net> wrote in article <01bc23ff$8bded340$6cc2b5cf_at_lisinc.flash.net>...
> Help! I am not an Oracle expert or user, but I have been tasked to find
> the following information:
>
> We have an Oracle database which is used to produce statements for
 clients.
> We are looking for a tool/method to automatically e-mail statements to
 the
> correct clients. The e-mail system is an internal Microsoft Mail server.
 

> It is important to control to whom the statements are sent, e.g.,
 statement
> a must only go to user a. In addition, if possible, we need an exception
> report for users not found on the email system.
>
> Any help would be appreciated.
> Thanks,
> --
> Ken Harris
> <http://research.umbc.edu/~kharris>
>
Received on Sat Mar 01 1997 - 00:00:00 CET