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