Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: calling executable within PLSQL

RE: calling executable within PLSQL

From: Reidy, Ron <Ron.Reidy_at_arraybiopharma.com>
Date: Wed, 30 Mar 2005 09:06:40 -0700
Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B43950A@fiji.arraybp.com>


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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of steve noyle Sent: Wednesday, March 30, 2005 8: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

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 Received on Wed Mar 30 2005 - 11:08:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US