| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: calling executable within PLSQL
Steve,
It's called an external procedure call or extproc. You cal look it up on Metalink and it's documented in the PL/SQL manual.=20
-----Original Message-----
From: steve noyle [mailto:stevenoyle1_at_yahoo.com]=20
Sent: Wednesday, March 30, 2005 10:57 AM
To: oracle-l_at_freelists.org
Subject: calling executable within PLSQL
Hello,
I'm looking for a method to call executable within
PLSQL. The executable resides on my database server
(HPUX).=20
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.=20
Is this feasible? Does anyone has any code that does that or has any suggestions? I'm running 9.2.0.6.=20
thanks.
steve
=09
__________________________________=20
 |
 |