Shell Programming and Scripting

echo "Calling dbquery1.sh...."
./dbquery1.sh
echo "Calling dbquery2.sh...."
./dbquery2.sh

sqlplus  -s user1/password1@DB_SID @/tmp/storedprocedures/Hello.rcp

./dbquery1.sh
if [[ $? -eq 0 ]] ; then
echo "Calling dbquery2.sh...."
./dbquery2.sh
fi

./dbquery1.sh && ./dbquery2.sh

echo "Calling dbquery1.sh...."
./dbquery1.sh > output.tmp
grep -q ORA- output.tmp
if [ $? -ne 0 ]
then 
echo "Calling dbquery2.sh...."
./dbquery2.sh
fi

$ cat bad.sql
whenever sqlerror exit failure
select this_produces_an_error from dual;
exit 0
$
$ cat good.sql
whenever sqlerror exit failure
select dummy from dual;
exit 0
$
$ sqlplus -s / as sysdba @good.sql

D
-
X

$ echo $?
0
$
$ sqlplus -s / as sysdba @bad.sql
select this_produces_an_error from dual
       *
ERROR at line 1:
ORA-00904: "THIS_PRODUCES_AN_ERROR": invalid identifier


$ echo $?
1