Thanks Clemens;

I have the ssh working well.

Regards;
Robert

-----Original Message-----

>
The information on this e-mail including any attachments relates to the official business of DigiCare (Pty) Ltd. The information is confidential and legally privileged and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised and as such any disclosure, copying, distribution or any action taken or omitted in reliance on it is unlawful. Please notify the sender immediately if it has inadvertently reached you and do not read, disclose or use the content in any way.
>
No responsibility whatsoever is accepted by DigiCare (Pty) Ltd if the information is, for whatever reason, corrupted or does not reach its intended destination. The views expressed in this e-mail are the views of the individual sender and should in no way be construed as the views of DigiCare (Pty) Ltd, except where the sender has specifically stated them to be the views of DigiCare (Pty) Ltd.
>

From: CLEMENS.BLEILE@(protected)]
Sent: 13 July 2006 18:26
To: Martin Berg; Robert Scheckle
Cc: suse-oracle@(protected)
Subject: AW: Re: [suse-oracle] How do I execute a remote 4gl from an
Oracle stored procedure?


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