Re: How can I send an email from a stored procedure ?

On Mon, 16 Sep 2002 20:33:39 -0300, "Javier Villegas" <jvillegas_at_impsat1.com.ar> wrote:

>Hi
>
>I need to send an email from a stored procedure if one result is grater than
>10
>
>how can I do that ?
>
>And if I need to run this stored procedure ever 5 minutes ?
>
>thanks in advance
>
>
>
>
>

Hi Javier,

By means of the UTL_SMTP supplied PL/SQL package and access to a SMTP server. See the online doc.

Run it either with DBMS_JOB or an OS job scheduling utility, i.e. cron on UNIX and "Scheduled tasks" on NT.

• Kenneth Koenraadt