Calling a plsql procedure from UNIX shell script

[gandolf989]

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