Re: How to ...

From: Chris Halioris <halioris_chris_nonlilly_at_lilly.com>
Date: 1997/08/01
Message-ID: <33E2334B.F80_at_lilly.com>#1/1


Jorge Meirim wrote:
>
> Everybody,
>
> Environment:
> Server = Unix 7.1 or 7.3
> Cliente = Dev 2K.
>
> How do I communicate with my Server?
> How do I start a script in Unix by pressing a button in Forms (Windows)
> Is It possible ?
> I'am sure there is something.
> Where to read about?
>
> Please Help
>
> Regards
>
> Jorge Meirim

One option is to use DBMS_PIPE to pipe a message to a process that is running on the Unix server. That process would be a shell script that runs a SQL*Plus script that waits for a message in the pipe. The SQL*Plus script gets the message and spools it to a file. The SQL*plus script then ends and the shell script regains control and does whatever you want with the file (it could run it if it was a command). The shell script then loops so it runs the SQL*Plus script and starts the process all over again. The shell script will always be running.

Chris Halioris Received on Fri Aug 01 1997 - 00:00:00 CEST

Original text of this message