Re: Can you send email from a stored Procedure?

From: Erwin Alberto <ealberto_at_mediaone.net>
Date: Wed, 02 Jun 1999 00:20:54 -0400
Message-ID: <3754B126.724A7C08@mediaone.net>

There are a couple of ways of doing it. If you are using Oracle 8i, you can write stored procedure to talk to Java Mail. This can be done both in NT and Unix. If you are using Oracle 8.0.x, you can call some dll function that sends email. Hope this helps you.

Erwin Alberto
PORT Consulting INC

Geogie Varughese wrote:

> Hi
> I am new to Oracle and I have a need to create an Ascii file using an
> oracle stored procedure. This I have done without a problem. The problem I
> have is I need to e-mail this ASCII file to certain people and I was
> wondering if I can do this from within the stored procedure. If any one can
> give some hints on this I would appreciate it
> Thank You
> Geogie
Received on Tue Jun 01 1999 - 23:20:54 CDT