将需要调用的存储过程写在文件tasklist.txt中
下面将批量执行文件列表中的存储过程
#!/bin/ksh
if [ $# -eq 0 ];then
echo "no paramer please input one paramer A OR B"
exit
fi
echo $1
echo "Now begin running....."
cat tasklist.txt | while read line
do
spname=`echo $line `
spname=$spname"('"$1"')"
echo $spname
startTime=`date +%Y%m%d%H%M%S`
echo $startTime
echo "begin exec procedures"
sql_str=`
sqlplus -S username/password@SID <<EOF
call $spname;
exit;
EOF`
endTime=`date +%Y%m%d%H%M%S`
echo $endTime
echo "end $spname exec procedures"
done
echo "end."