Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Need to start a program on a server with client application

Re: Need to start a program on a server with client application

From: Walter Dorninger <wdor_at_magnet.at>
Date: Sun, 19 Sep 1999 13:23:22 +0200
Message-ID: <7s2gfj$fdu$1@orudios.magnet.at>


nope - sorry as fare as i know these are the only two mechanisms. I have had the same problem and I have solved it as follows: (1) created a table in the db where the "host"-command is stored by the client app
(2) witten a pro*c program (approximatly 20-40 lines) where I uses the dbms_alert package to check if there is a row in the table (with the dbms_alert package you can avoid polling). (3) if there was a row then read it and execute it with the system function in C

hope this helps
-Walter-

David Dieudonné <dvdieudo_at_club-internet.fr> wrote in message news:7s0vj3$oo5$1_at_front7.grolier.fr...
> I have a client/server application, with Forms 4.5 for Windows 95 on the
> client and Oracle 7.3.2.3 for HP_UX on the server side.
>
> I need to design a mechanism to start a program (writed with Pro*C)
running
> on the server side with the client application.
>
> Are there tools to do it easily ?
>
> Otherwise, the solutions I envisage are :
> - using dbms_pipe (a daemon read messages and start programs).
> - using a database table where daemons read
>
> All ideas are welcomed.
>
> Thanks.
>
>
Received on Sun Sep 19 1999 - 06:23:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US