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@xxxxxxxxx]=20
Sent: Wednesday, March 30, 2005 10:57 AM
To: oracle-l@xxxxxxxxxxxxx
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
Do you Yahoo!?=20
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/=20
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: