Re: Pro C question (also about Java versus C)

Two ways -

1. For all versions (Oracle 7 onwards), use a pipe (dbms_pipe) to wake up the server side program - i.e the client places a message on the pipe, the serverside program is polling on the other end. Thomas Kyte has a nice implementation of the PL/SQL and C source required called Plex, see http://govt.oracle.com/~tkyte/plex/
2. From Oracle8 onwards, consider External Procedures. These are similar to datablades in Informix - see http://technet.oracle.com/doc/server.804/a58236/10_procs.htm (note the reference is for version 8 docs, if you are on Oracle8i you should use the 8i documentation)

Note that both implementations have different session semantics - pipes via Plex may be your quickest and easiest solution for conversion

in article 20010406215403.28177.00004851_at_ng-mi1.aol.com, VWP914 at vwp914_at_aol.com wrote on 4/6/01 6:54 PM:

> Is it possible to run a server side Pro C application from a network clent?
>
> I have about 2 dozen Informix/ESQL-C programs that I am converting to Oracle
> Pro C.
> My client application must be platform independent, so I am coding that in
> Java.
> The best way i can think of how to do this is to write the Pro C application
> as a shared library that can be accessed by PL/SQL. The Java client program
> would then call the PL/SQL procedure which would then call the Pro C app.
>
> Does anyone have any other ideas of how to do this? Or should I just give up
> the ghost and start converting all the Pro C server side apps to client side
> Java?
Received on Fri Apr 06 2001 - 21:48:50 CDT