Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can I Send E-Mail using PL/SQL Stored Procedure

Re: Can I Send E-Mail using PL/SQL Stored Procedure

From: Steve A <spectre_at_hkstar.com>
Date: Thu, 28 Oct 1999 15:44:50 +0800
Message-ID: <1e0e657.1iby8cp1uvu5neN@[201.1.1.74]>


Hi,
The way I'm doing it is to use the utl_file package, to write the control files into the email program's directories

You need to figure out the format that the email program is using, then it's a simple matter to reconstruct the files format using sql.

I'm suprised how well it works.

I'm currently working on a system to handle email Queries to our oracle database.

steve

<nicky_at_unilinknet.com> wrote:

> Hi
> Can anybody help me
> I use Windows NT4 Server, Oracle 8i and OAS 4.0.7 in the same machine
> I need to send e-mail using PL/SQL stored procedure
> Can I do this?
>
> 10x
> Nicky
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Oct 28 1999 - 02:44:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US