Re: Executing Unix commands from PL/SQL possible?

Jim Cox wrote:

> Atif Ahmad Khan wrote:
> >
> > I am wanting to put a simple Unix command like :
> >
> > echo "Order Number 123 cancelled by customer" | mail salesperson
> >
> > in a PL/SQL package. Is this possible?
> >
> > I read something about a PLEX tool on Oracle Govt. web site. Is
> > that supposed to help in achieving something like this?
> >
> > Thanks a million.
> >
> > Atif Khan
> > aak2_at_ra.msstate.edu
>
> Try "host" works for printing and some other things.
>
> Jim

Sorry,

'host' is not a valid PL/SQL command.

The best and easiest way is to use DBMS_PIPES (i.e. establish a daemon on your server that will perform this task for you, and have your othe PL/SQL package send messages to it). Received on Wed Jun 11 1997 - 00:00:00 CDT