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: Call other program inside Pl/SQL

Re: Call other program inside Pl/SQL

From: Mark Gumbs <mgumbs--AT--hotmail.com>
Date: Wed, 12 May 1999 09:03:55 +0100
Message-ID: <373933b0.0@145.227.194.253>


A non-web based way of doing it would be to copy the e-mail address, message, subject etc to an oracle table. Then have a cron (if using unix) to run a sql script (say every 5 seconds) which will check to see if there are any messages in a table. If so, the data can be extracted from the table into unix variables and unix mail can be called with the unix variables as parameters.

HTH Mark
wweng_at_ei.org wrote in message <7h9m1c$mln$1_at_eipipeline.ei.org>...
>Is it possible to call another program, say mail(in UNIX), inside a PL/SQL
>script?
>
>
>I am implementing a web interface, require to email a certain user when
>a button is clicked. How should i do it?
>
>Thanks in advance
>
>wei
>
Received on Wed May 12 1999 - 03:03:55 CDT

Original text of this message

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