Robert Scheckle wrote:
> All;
>
> I have this really interesting scenario.
>
> I have an Oracle stored procedure that needs to execute a 4gl program on
> a remote server.
>
> Can this be done or do I need to find another solution?
>
>
>  
The problem can be described as two problems:
a) calling an external program from PL/SQL
b) calling a 4gl program on another machine

a) Can be done with the external procedure interface in Oracle
(available since Oracle 8)
It requires an Oracle Net listener process to service the "extproc" service.
For security reasons this listener should NOT be owned by the normal Oracle
OS user (as this can create a security hole).

The external procedure interface is described in the Oracle Database
Application
Developers Guide - Fundamentals (chapter 8 in the 10.1 docs and chapter
14 in the
10.2 docs).

b) How do you call programs on another machine ? - for the man with only
a hammer
(where all problems needs to be a nail) the solution could be to install
an Oracle on
the remote machine, call the external program from within a stored
procedure on
this database and then call this procedure via a database link between
the two
databases (Oracle Net).


--
Med venlig hilsen

Martin Berg

email: martin@(protected)
web: www.berg-consult.com
mobil: 30 35 58 68


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting