Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: calling executable within PLSQL
steve noyle apparently said,on my timestamp of 31/03/2005 1:57 AM:
> I found a number of sample code that creates oracle
> function/java program to do what I need. However, I'm
> not able to find any information on how I can run the
> executable remotely. What I meant by remotely is I
> want to be able to initiate the function/procedure
> from another Unix server or from my windows client
> other than from my database server. Everything works
> well if I log in to the database from my database
> server and initiates the function from there but it
> fails if I initiate it from my PC since it has no
> access to the executable on the database server.
>
> Is this feasible? Does anyone has any code that does
> that or has any suggestions? I'm running 9.2.0.6.
>
If I understand what you want to do, it should run from your windows client? It will still execute in the db server, but it will be initiated from the client by a PL/SQL exec call?
-- Cheers Nuno Souto in sunny Sydney, Australia dbvision_at_iinet.net.au -- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 30 2005 - 18:02:08 CST