Yes, that would another way ;-)


CLEMENS.BLEILE@(protected):
> 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
>>
>>  
>
>
>  


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