$ cat 1.sh
#!/usr/bin/ksh
integer rows1 rows2
echo "Start ..."
echo "parameter count : $#"
if (($# != 2)) ; then
echo "Parameter count error"
echo "Usage: $0 key1 key2 "
exit
fi
sqlplus -s oraid/orapwd @1.sql $1 > tabs21
cat tabs21
rows1=`cat tabs21|grep RETURN | sed 's/RETURN.//'`
sqlplus -s oraid/orapwd @1.sql $2 > tabs22
cat tabs22
rows2=`cat tabs22|grep RETURN | sed 's/RETURN.//'`
echo
echo "key:$1 -> rows1:$rows1"
echo "key:$2 -> rows2:$rows2"
echo
if ((rows1 != 0 || rows2 != 0 )) ; then
print -u2 OK
else
print -u2 NOT OK
fi
echo "End"
############################# END ####################################################
$ 2.sql
SET SERVEROUTPUT ON
SET FEEDBACK OFF
DECLARE row_count NUMBER;
BEGIN SELECT COUNT(*) INTO row_count FROM TABLE_NAME WHERE key = '&1';
--DBMS_OUTPUT.PUT_LINE(row_count);
DBMS_OUTPUT.PUT_LINE('RETURN:' || row_count);
END;
/
EXIT
