Calling PL/SQL Script in Shell Programming

lijju.mathew · #1 (**permalink**) 05-16-2007

Hi all,

In a shell script I need to pass two parameters to a pl/sql script and get the ouput of the pl/sql script and use it in shell script.

For example

Shell script : test.sh

PL/SQL script : get_id.sql parameter1 parameter2

Actually get_id.sql has a select statement something like this

select max(sal) from emp where emp_id in (parameter1,parameter2)

Now I need to get the max(sal) from the sql script back ino the shell script say a variable and echo it .

Would be great if you outline the script at a high level..

Thanks in advance
LM

Shell_Life · #2 (**permalink**) 05-16-2007

Lijju,
See if this would work for you.
Create a shell file named "my_shell.sh" as follows:

Code:

mParm1=$1
mParm2=$2
mSQL="database your_database;"
mSQL=$mSQL"select max(sal) from emp where emp_id in (${mParm1},${mParm2});"
echo $mSQL
echo $mSQL | <sql_pgm_call> 1>mOutFile 2>>mLogFile

<sql_pgm_call> is the name of the program you use to run your
SQL statements, ie, in Informix is either isql or dbaccess.

Then call the above shell as:

Code:

my_shell.sh first_parm second_parm

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Calling a shell script from php	eltinator	Shell Programming and Scripting	1	04-22-2008 01:16 AM
Calling shell functions from another shell script	jisha	Shell Programming and Scripting	6	04-05-2008 04:29 PM
Calling Shell Script	onlyroshni	Shell Programming and Scripting	1	10-22-2007 07:29 PM
calling a shell script from perl	gurukottur	Shell Programming and Scripting	3	10-05-2006 11:48 AM
Calling shell script ?	Ravi_Kandula	Shell Programming and Scripting	1	10-07-2002 09:30 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