Re: E-mail from PL/SQL procedure

Couldn't you create the html page with a vbscript program and run it from the nt command line via a schedule utility? Then, when the file is created, just send an email from the command line using Jmail, or use automation to send it through Outlook or something similar?

If it has to be in the database on 7.3.4, Oracle has a sample "daemon" that you can compile (Visual c++) and it would handle this type of operation. You'll probably have to do some work though. On 8.0, you can call external procs to send email, and I have examples of how that's done.

I've never tried COM automation, but there's an example on Technet that shows how to do mailings with that on an 8.1.5 instance, and you can probably do it with Java too.

Good luck!

rmarkd_at_my-deja.com wrote in message <8j024d$6lf$1_at_nnrp1.deja.com>...
>We're using Oracle 7.3.4 (presently, though moving to 8i) on WindowsNT.
>I have been asked to find out if and how to run a PL/SQL script on a
>certain time of day that would e-mail the query (using the htp package
>to put appropriate HTML tags) to various people. Can this be done?
>Do I need 3rd party software? Would 8i make this easier? Can anyone
>point me to a website that would have this information?
Received on Fri Jun 30 2000 - 00:00:00 CEST