UNIX for Dummies Questions & Answers

Hi ,

i have written a shell scipt to call a procedure and get the value back from procedure.But i am facing the issue like
#!/bin/sh
returnedvalue=`sqlplus -s userid/pass<<EOF
set serveroutput on;
exec pass($1)
set serveroutput off;
EXIT;
EOF`
flag=`echo $returnedvalue `
echo "$flag" > check.log
if [[ $flag == 1 ]]
then
echo "flag" >> check.log
else
echo "no flag" >> check.log
fi

Output i am getting as
flag =1 PL/SQL procedure successfully completed.

but i need only 1 as output not PL/SQL procedure successfully completed.

any help .

Then use:

Code:

if echo "$flag" | grep "^1 " >/dev/null 
then 
...

another way
you can specify "set feed off"
after "set serveroutput on" line