How to capture only the stderror in this bash script?

Question

this is my scash script

 query="select * from blabla;"    
    sqlplus64 -S /nolog <<ENDOFSQL>>errorLog.txt 
               CONNECT username/pwd@domainName:1521/serviceName
               whenever sqlerror exit sql.sqlcode;
               $query 
               exit;
    ENDOFSQL
               ERRORCODE=$?

                   if [ $ERRORCODE -eq 0 ];
                      then
                          echo  "$query" >> "sqlTemp.SQL"
                          echo  -e  "$query \n this query is successful" 

                      else
                          echo -e "$query \nthis query has  error- check the log file for detail" 

                   fi

My requirement is to collect only the error, instead I am getting all error and successful data.

I have tried

1.sqlplus64 -S /nolog <<ENDOFSQL2>>errorLog.txt 
2.sqlplus64 -S /nolog <<ENDOFSQL 2>&1>errorLog.txt

I can't use a pipe as errorcode will not receive the desired error code.

Have you tried `sqlplus64 -S /nolog <>errorLog.txt`? With a space before the `2`? — terdon, Jun 13 '17 at 08:11

score 1 · Answer 1 · answered Jun 13 '17 at 07:35

1

use the bash redirection

Script.sh 2> Error.log

answered Jun 13 '17 at 07:35

SHW

14,454
14
63
101

How to capture only the stderror in this bash script?

1 Answers1