how can i call a shell script from pl/sql

rajesh.P · #1 (**permalink**) 09-14-2007

I would like to call the shell script from pl/sql and i need to uses the value returned by the shell script in pl/sql procedure.

can any one suggest me how can i do that?

radoulov · #2 (**permalink**) 09-14-2007

You can do it with Oracle >= 10g.
Check dbms_scheduler's documentation (create_job, job_type=>'executable').

rajesh.P · #3 (**permalink**) 09-14-2007

but iam doing this in oracle 9i, we can't use dbms_scheduler in 9i

how can i acheive this in oracle 9i

Ygor · #4 (**permalink**) 09-16-2007

http://www.unix.com/shell-programmin...procedure.html

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
URL call from SHELL script	chengwei	Shell Programming and Scripting	37	04-15-2009 09:52 PM
Call shell script from php not run ?	raccsdl	Shell Programming and Scripting	2	11-19-2007 08:21 AM
To call/execute a shell script from a shell script	konark	UNIX for Dummies Questions & Answers	1	10-26-2007 05:16 PM
how can a call shell script from pl/sql	rajesh.P	UNIX for Dummies Questions & Answers	0	09-14-2007 02:42 AM
How to call a shell script from awk ?	Amruta Pitkar	Shell Programming and Scripting	1	04-20-2007 04:35 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by