Re: email-enabling webdb/plsql/db application

There are a couple of options here. I have successfully used a tool from http://hayden.home.mindspring.com/newproducts.htm called hwmail. It runs as a process on an NT machine (only) and connects to Oracle via SQLnet (on any platform). A couple of procedures give the ability to send email from PL/SQL, I'm not sure if it handles attachments.

The other option is to upgrade to 8.1.6 as Oracle now provide a utl_smtp package to send email from the db. I haven't had time to look into this yet.

Both require network access to an smtp server ( I think exchange is)

Hope this helps.

On Thu, 9 Mar 2000 16:27:22 +1000, "Mark Hills" <m.hills_at_exec.com.au> wrote:

>Hi all,
>
>I am running WebDB2.2 over Oracle 8.1.5 on NT4SP5 and have a requirement to
>send emails based both on events in the webdb application (if you can call
>anything built in webdb an application!) and on certain events in the
>database. The messages may well have to have attachments (which will either
>be in the database or available on the same server as the database).
>
>The customer uses Exchange as their mail server.
>
>The customer's staff may have disparate client-side email software and are
>located both on and off site, so I think that the mailing has to be done
>from the server side .
>
>I imagine that I will need some sort of interface through pl/sql (or maybe
>java?) to a mailing mechanism.
>
>Does anyone have any experiences/suggestions as to how best to do this? Am I
>asking too much of the products involved?
>
>Thanks in advance,
>Mark Hills.
>
>
>
>
Received on Fri Mar 17 2000 - 23:23:22 CET