Re: Help: I need to trigger a Unix program from

In article 12780_at_ctp.com, jtang_at_ctp.com (Joe Tang) writes:
>
>>From a PC with Oracle Net, connected to an Oracle Server on an RS6000
>(Oracle Version 7), I need to initiate/trigger a Unix program (acutally
>a COBOL program that is compiled to an executable) on the IBM.
>
>I hoped I could do it with a trigger on a table (in which I dump the
>arguments to the COBOL program), but triggers can only execute PL/SQL
>commands from which I don't know how to fire up a system command. I
>need something like the "HOST" command which is available only from
>SQL/Forms.

The way we do it is to have the form update a queue table, which in turn is inspected via a 'cron job' on the executing host. If the necessary information and parameters are sitting in the queue table the host executes whatever is necessary and publishes the results to a returning table. This IMHO is safer than using HOST commands or similar because then it doesn't matter where and on what platform you execute your forms.

Regards,
David TvE

---
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
David Thornewill von Essen                           Sr. Systems Analyst
Motorola ASIC Division                            I don't speak for Mot.
Chandler, AZ-85224                                   fax: (602) 814-4451
email: ttg242_at_email.sps.mot.com                      tel: (602) 814-4395
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-