Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Call unix command in package
There isn't a direct way of calling unix commands.
You can use External_Procedures or a freeware (or is is shareware) package
called PLeX.
Alternatively, why don't you let UNIX do the donkey work. Use UTL_FILE to create a batch file containing all your mail commands and message.
e.g
mail kingkong_at_windycity.com "Tablespace Blonde_Woman Full"
mail kingkong_at_windycity.com "ORA-03132"
and set up a unix cron (or at) to look for this batch file and run it.
Mark
KC <kcheung_at_poboxes.com> wrote in message
news:37F37D85.6BD324C6_at_poboxes.com...
> Hi all,
>
> Is it possible to call unix command in stored procs or packages?
> Cos' we want to implement a mail function to alert users for any records
> found in a exception table.
>
> Thanks,
> Kevin
>
Received on Fri Oct 01 1999 - 04:53:34 CDT