Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLPlus return code inconsistency
persdoc1_at_yahoo.com (arun) wrote in message news:<867425c2.0207041816.7dd81c46_at_posting.google.com>...
> sqlplus -s << --eof_espool 2>&1 > "$_jspool_tempfile"
> $SCOPE_SQL_USERID/$SCOPE_SQL_PASSWD@$SCOPE_TNS
> WHENEVER SQLERROR EXIT 1
> set head off
> set pagesize 0
> set timing off
> set autotrace off
> set feedback off
> set termout off
> set trimspool on
> set echo off
> set colsep ""
>
> -- This ensures that extra large SELECT clauses are got into
> the same line
> set linesize 2000
>
>
> spool $_spoolfile
> @$_jspool_tempsqlfile
> spool off
> exit 0
> --eof_espool
> sqlstatus=$?
>
> if [ "$sqlstatus" -ne 0 ]"
>
> "
>
> As explained above, the sqlstatus variable is set to non zero after
> nth query ( where n is some random number). The same sqlstatus
Interesting. When it's non-zero, what is its value?
Yong Huang Received on Fri Jul 05 2002 - 11:15:35 CDT