RE: calling executable within PLSQL
- From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
- To: <stevenoyle1@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 30 Mar 2005 09:06:40 -0700
Steve,
Are you trying to run a program on your local PC, or on the db server, =
or on a completely different server? If the db server, look into using =
extproc; if a different server, look into SOAP and/or RPC; if on your =
local PC, I think SOAP again, but not too sure about this one.
-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of steve noyle
Sent: Wednesday, March 30, 2005 8: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
This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.
--
http://www.freelists.org/webpage/oracle-l
Other related posts: