On 20 Aug 2001 21:23:14 -0700, stemp1ar_at_yahoo.com (Simon) wrote:
>Any help would be great...TIA
>
>check_error() {
> if [[ -a errfile ]]; then
> err_count=$(grep -c -e ^[^$] errfile)
> else
> err_count=0
> fi
> if (( err_count > 0 )); then
> echo "\nErrors have been encountered. Please refer to
>errfile"
> fi
>}
> sqlplus -s > test.out 1>errfile 2>logfile <<EOF
> username/pass
> whenever sqlerror exit failure
> set serveroutput on
> spool outfile
> select count(*) from table_name;
> spool off;
Delete this line? -----> exit;
> EOF
>
> RC=$?
> if [[ $RC = 0 ]]; then
> echo "Inside zero rc=$RC"
> else
> echo "Inside non-zero RC=$RC"
> exit -1
> fi
>
> check_error
Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam
Received on Tue Aug 21 2001 - 04:40:09 CDT
