Re: Calling sqlplus or plsql code from ksh

  > sqlplus -s >/dev/null 2>&1 <<EOF
> monitor/oramon
> whenever sqlerror exit 1
> select * from dual;
> -- If we can not connect or select, we will not return 0!!!
> exit 0
> EOF
>

Or this way:
sqlplus -s /nolog >/dev/null 2>&1 <<EOF
connect monitor/oramon
_your_sql_statements_
EOF Received on Fri Feb 20 2004 - 01:24:44 CST