Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

Sample Code


Starting Unix Script from pl/sql procedure


I would like to start any unix shell script out of oracle. I don't want use DBMS_PIPES, because then I always need a unix daemon.  Is there a package wich allows to a call similar to "os_result := dbms_systemcalls.call_unix_system ('/usr/bin/ls -la'); null

quote:<HR>Originally posted by Christoph: I would like to start any unix shell script out of oracle. I don't want use DBMS_PIPES, because then I always need a unix daemon.  Is there a package wich allows to a call similar to "os_result := dbms_systemcalls.call_unix_system ('/usr/bin/ls -la');<HR>  I would also be very interested in such a package.  Thanks,  Jeff Alexander jalexand@regents.edu  null

What version of Oracle are we talking about here? If it's v8 then I think what you're after is a pl/sql external procedure which I can tell you how to set up.  Andy  quote:<HR>Originally posted by Christoph: I would like to start any unix shell script out of oracle. I don't want use DBMS_PIPES, because then I always need a unix daemon.  Is there a package wich allows to a call similar to "os_result := dbms_systemcalls.call_unix_system ('/usr/bin/ls -la');<HR>  null

quote:<HR>Originally posted by andy.davis2: What version of Oracle are we talking about here? If it's v8 then I think what you're after is a pl/sql external procedure which I can tell you how to set up.  Andy   <HR>  I am using 8.1.5. Could you e-mail me the instuctions at jalexand@regents.edu, thanks -Jeff

We use Oracle 8.1.6. Can you mail me the answer also to christoph.widmer.2@clariden.com

Suspect that the external pl/sql call process might also solve my problems with emulating the db2 timestamp. Please email any samples to stephen.burkholder@sasktel.sk.ca. Are there any performance concerns withe the external call process?

I am also interested in how it can be done. I am using Oracle 8.1.5  Thanks Andy  quote:<HR>Originally posted by andy.davis2: What version of Oracle are we talking about here? If it's v8 then I think what you're after is a pl/sql external procedure which I can tell you how to set up.  Andy   <HR>  null

can't u use the ! command ? e.g sql> !ls will perform ls shell command  out of the sqlplus

would u like email to me(aisir@sina.com) about external procedure? i'm using 8.1.5. thanks.

 I am also interested in how it can be done. We use Oracle 8.1.5 Please Email me the solution at Segun99@aol.com  Thanks Andy  null

I'm also interested in the external procedure. Can you email me at steve.miller@oyster.co.uk thanks.

I am using v8. Could you e-mail me the instuctions at EPaul@kzvh.de, thanks  Edgar  quote:<HR>Originally posted by andy.davis2: What version of Oracle are we talking about here? If it's v8 then I think what you're after is a pl/sql external procedure which I can tell you how to set up.  Andy   <HR>  null

quote:<HR>Originally posted by andy.davis2: Would you also send me instructions?  I'm using 8.1.6 ..  thanks!!   What version of Oracle are we talking about here? If it's v8 then I think what you're after is a pl/sql external procedure which I can tell you how to set up.  Andy   <HR>  null

Hi all,  Can you please email sample code for this? Or put the sample code in this forum ?  Thanks,  Raghu.  s.raghuraman@ind.xerox.com

I would also be very interested in such a package.  Thanks,  Suresh.


Related Links

AQJMS Example
Referential Integrity
Conversion of Long Raw to Varchar2
logging into oid with certs
Errors in sample code?
OTN MOBILE WEB SERVICE: WRONG ENDPOINT
ODP.Net memory/buffer problem ??
Urgent
How to create a tree ?
LOBSample.jar - how to download it?
Forms 9i
CPGA Install Problem
FBS Sample Application - Unable to deploy
Oracle Internal Error Problem
INITIAL extent Unable to create any table .... Urgent
aggregate