You can redirect output from sqplus to a variable. Just be aware that 9i ignores the -s switch.
You can then check the variable for whatever it is you are looking for.
PLSQL_RESULTS=`sqlplus -s '/as sysdba' <
set term off
set echo off
set pagesize 0
set feedback off
set timing off
set serveroutput on
set term on
exec runMyProc;
EOF
Here is a simple SQL example.
DB_STATUS=`sqlplus -s '/as sysdba' <
set term off
set echo off
set pagesize 0
set feedback off
set timing off
set term on
select status from v\$instance;
EOF
if [ "${DB_STATUS}" == OPEN ]
then
echo "The database is open"
else
echo "The database is not open"
fi
this space intentionally left blank