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: Unix shell commands in Trigger?

Re: Unix shell commands in Trigger?

From: <rajg_at_rocketmail.com>
Date: 2000/07/30
Message-ID: <8m1cii$2gq$1@nnrp1.deja.com>#1/1

In article <1db50108.824aa8bd_at_usw-ex0101-008.remarq.com>,   Pavan <c_pavanNOc_SPAM_at_usa.net.invalid> wrote:
> Raj
>
> You can you UTL files for writing into a flat file. Further more
> to fire some Shell commands you can run a script file thru Cron
> job utility i.e as soon as the logfile is created.

Thanks for the tip. The possible problem with cron job could be the overhead on the system, since there will be occasions when there would constant updates (and invokation of trigger) and firing a cron job for each instance of the trigger may make things haywire.

So, is there no way to run a shell command from a trigger?

thanks
raj

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Jul 30 2000 - 00:00:00 CDT

Original text of this message

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