Hi,

why not calling the external program (your case a.) ) and doing an ssh to the remote machine?

Ciao

Clemens

--- Originalnachricht ---
> 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
>


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