Re: Calling HOST command from forms

Roya Mehrfar wrote:
>
> I would like to call a c program which resides on my server (which is a
> unix box) from my forms 4.5 running on my client (a Mac). I can't use
> the host command since host goes to the operating system of client
> (Mac). Someone told me to write a database trigger to call the C program
> from the server. But how do you call to the server from a data base
> trigger. Any help would be greatly appreciated.
> Thanks

Roya,

In order to execute things on the server from the client, we've setup an Oracle package in the database which uses a pipe through which to pass the server command line. What you may want to do is setup a C program, or some other product, as a listener to a pipe (DBMS_PIPE). Have your client use a DB package w/in Oracle to pass the server command line. Then, the listener you have setup on the server will get the message, unpack it, and issue the command to the server. We've setup an intricate messaging system in order to move report generation from the client to the server, reducing network traffic, and letting the power of the server do all the work.

Let me know if you want to know more.

Joe Tseng
Consultant
TUSC tsengj_at_tusc.com Received on Wed Apr 30 1997 - 00:00:00 CEST