Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Call other program inside Pl/SQL
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