Re: Executing UNIX shell commands from trigger

From: Eric Keen <ekeen_at_dps-corp.com>
Date: 1998/03/01
Message-ID: <34F980E3.77342677_at_dps-corp.com>#1/1


Thomas Hilke wrote:
>
> Harvey,
> I think it's not possible to use a HOST command in a PL/SQL Block like a
> trigger.
> The HOST command works only in SQL*PLUS.
>
> Tom.
>
> Harvey Mark wrote in message
> <14D46DF9FC08D111AF8700805F68C0CF1551FB_at_CONNERY>...
> >
> >
> > If you are running Developer 2000 client server then it's
> >tricky.
> >
> > If you are running your applications on the server just use the
> >HOST
> > command.
> >
> > mark
> >
> >
> >> ----------
> >> From: Peter Chan[SMTP:chanp_at_bnr.ca]
> >> Posted At: 06 February 1998 18:47
> >> Posted To: tools
> >> Conversation: Executing UNIX shell commands from trigger
> >> Subject: Executing UNIX shell commands from trigger
> >>
> >> I was wondering if it is possible to execute shell commands from
> >> ORACLE
> >> triggers.
> >>
> >> If so, please show me how to do this.
> >>
> >> Thanks!
> >> --
> >>
> >>
> >> ======================================================================
> >>
> >> PETER CHAN
> >> Northern Telecom
> >> Incremental Software Delivery
> >>
> >> PHONE: (613) 763-9096 EMAIL: chanp_at_nortel.ca
> >> FAX: (613) 763-4408
> >>
> >> ======================================================================
> >>
> >

An efficient and secure way is through Oracle DBMS Pipes. It's a simple message queue that informs a waiting program that client work awaits. The best part this that notification is immediate, and no resources are used in "checking" for work.

Our company is looking for BETA customers this Spring who are willing to trial our product, SQL*Pipeline. It allows simple remote execution of shell scripts or host programs via stored procedures (passing parameters and returning exit codes and data). You can even use the native dbms_jobs package to schedule jobs.

If you are interested, please check our Web Site at http://www.dps-corp.com/prod.htm or contact us by phone or e-mail. Our number is 410-321-8444. Ask for Paul Tuma or myself.

We currently support AIX and HP-UX (while always looking for other platforms).

Regards,

Eric Keen
Director Product Development
DPSC
Towson, MD 21286 Received on Sun Mar 01 1998 - 00:00:00 CET

Original text of this message