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.

ttg242_at_newton.sps.mot.com (David Thornewill von Essen) writes:
>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.

I think David's solution is pretty good, but if you want to get away from a polling solution, and yet still get good granularity of response, I'd suggest using database pipes (NB: similar to, but not the same as, Unix pipes). This facility is documented in an appendix in the Application Developer's volume of the Server documentation trilogy. Rather than launch into a big explanation here, take a look at the description of the facility (an asynchronous inter-process communication facility) and mail me if you'd like more info.

Regards,

Ken

--
Ken Stewart,                    Telephone:   (301) 907 2225
Oracle Federal,     	        Fax:         (301) 657 0037
Bethesda, MD 20814              Internet:    kstewart_at_us.oracle.com