Re: Excuting shell commands from trigger
Date: 1998/02/07
Message-ID: <34DBB82A.869719D0_at_mitchells.demon.co.uk>#1/1
If it is a database trigger you can not make use of the host command. You can however make use of the very useful package dbms_pipe. Have a look in $ORACLE_HOME/rdbms/admin/dbmspipe.sql for more information.
Avinash Deshpande wrote:
> Yes, it is possible...
>
> use HOST command.
>
> HOST(system_command_string);
>
> Avinash
>
> Peter Chan wrote:
> >
> > I was wondering if it is possible to execute UNIX shell commands
from
> > a trigger?
> >
> > And if it is possible, how is this done.
> >
> > Thanks!
> > --
> >
> >
> ======================================================================
>
> >
> > PETER CHAN
> > Northern Telecom
> > Incremental Software Delivery
> >
> > PHONE: (613) 763-9096 EMAIL: chanp_at_nortel.ca
> > FAX: (613) 763-4408
> >
> >
> ======================================================================
Received on Sat Feb 07 1998 - 00:00:00 CET