Re: Help: I need to trigger a Unix program from Oracle Net on a PC

In article <1993Aug25.170056.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.
>
>Any help would be greatly appreciated!
>
>Thanks in advance,
>Vijay Kotrappa
>(310)416-4694
>vijay_at_caesi.scg.hac.com
>

Use a DBMS Pipe... You can send a message through the pipe to a daemon that will spawn your OS process. You could also use the procedural gateway, but I think it's still in beta test, and it costs more.

• Dan

Daniel Druker
Anderson Graduate School of Management at UCLA                    

| Dan Druker                                                               |
| agsm mail 	: ddruker                                                  |
| internet 	: ddruker_at_agsm.ucla.edu                                    |
| oracle*mail	: unix:ddruker_at_agsm.ucla.edu                               |
----------------------------------------------------------------------------

Disclaimer: None. I'm a student now and I don't care what you think. Received on Wed Aug 25 1993 - 20:56:17 CEST