Shell Programming and Scripting

SP2-0734: unknown command beginning "return :va..." - rest of line ignored.
SP2-0734: unknown command beginning "return :va..." - rest of line ignored.

sqlplus -s system/xxxx << EOF
set pages 0
set head off
set feed off
variable var1 varchar2(10);
variable var2 varchar2(10);
begin
select num_rows into :var1 from DBA_TAB_PARTITIONS where TABLE_NAME='TABLE1' and table_OWNER='AAA'
and PARTITION_POSITION=(select max(PARTITION_POSITION)-3 from DBA_TAB_PARTITIONS where TABLE_NAME='TABLE1' and table_OWNER='AAA');
select num_rows into :var2 from DBA_TAB_PARTITIONS where TABLE_NAME='TABLE2' and table_OWNER='PPP'
and PARTITION_POSITION=(select max(PARTITION_POSITION)-3 from DBA_TAB_PARTITIONS where TABLE_NAME='TABLE2' and table_OWNER='PPP');
end;
/	

return :var1;
return :var2;
EOF
echo $var1
if [ $var1 -gt 0 ]; then
echo "condition 1......." 
fi

echo $var2
if [ $var2 -gt 0 ]; then
echo "condition 2...." 
fi

#!/bin/ksh
sqlplus -s system/xxxx << EOF >myfile.txt
set pages 0
set head off
set feed off
select num_rows 
      from DBA_TAB_PARTITIONS 
      where TABLE_NAME='TABLE1' 
             and table_OWNER='AAA'
            and PARTITION_POSITION=
            (select max(PARTITION_POSITION)-3 
              from DBA_TAB_PARTITIONS 
              where TABLE_NAME='TABLE1' and table_OWNER='AAA');
select num_rows
      from DBA_TAB_PARTITIONS 
      where TABLE_NAME='TABLE2' 
      and table_OWNER='PPP'
and PARTITION_POSITION=(select max(PARTITION_POSITION)-3 from DBA_TAB_PARTITIONS where TABLE_NAME='TABLE2' and table_OWNER='PPP');
EOF
cnt=0;
while read rec 
do
  arr[$cnt]="$rec"
  cnt=$(( $cnt + 1 ))
done
# you now have an array arr with 2 elements
echo "first element = ${arr[0]}"
echo "second element = ${arr[1]}"