05-01-2007
148,
0
Join Date: Jul 2006
Last Activity: 17 October 2012, 10:54 AM EDT
Location: Mysore
Posts: 148
Thanks Given: 2
Thanked 0 Times in 0 Posts
But for Oracle 10g, our job is using "SQLPLUS.SH".
What is the syntax to use "SQLPLUS.SH". Also I've to store the result of this SQLPLUS call to one variable.
RESULT=`sqlplus.sh -s $USERID_PASSWORD $SQLFILE $PARAMETER`
In the above case Iam not able to assign the result to variable and also not able to use -s option.
Could you pls suggest.
Ganapati.