问SQL查询在运行shell脚本时返回0，而在检查db时返回6。

EN

#!/bin/ksh
. /apps/path/config/setenv.ksh
DATE=`date "+%m%d%Y`
returnMessage="`sqlplus  username/password@$ORACLE_SID << EOF
WHENEVER OSERROR EXIT SQL.OSCODE ;
WHENEVER SQLERROR EXIT SQL.OSCODE ;

spool /apps/path/data/test.txt
SET HEADING OFF
SET FEEDBACK OFF
SET VERIFY OFF
SET ECHO ON
SET PAGES 0
SET LINESIZE 90

select count(*) from table where dt = to_date('06/18/2020','MM/DD/YYYY');
EOF
`
"
        exitCode=$?
        oracleError=`echo "$returnMessage" | grep ORA-`
        if [ -n "$oracleError" -o "$exitCode" -ne 0 ]; then
                log "An error occurred while looking up the $COUNT"
                log "SQLPlus Exit Code = $exitCode"
                log "SQLPlus Message is: $returnMessage"
                return 1
        fi
        export COUNT=`echo $returnMessage"
        return 0

SQL> SET HEADING OFF
SQL> SET FEEDBACK OFF
SQL> SET VERIFY OFF
SQL> SET ECHO ON
SQL> SET PAGES 0
SQL> SET LINESIZE 90
SQL>
SQL> select count(*) from table where dt = to_date('06/18/2020','MM/DD/YYYY');
         0
SQL>