if [[ ${rcloop1} -eq 0 ]]; then
      sql_cnt_loop=0      
      # perform 2nd loop after 1 second to check if Indexing has completed
      sleep 1
      while : ; do
         exec_SQL "SELECT count(*)    \
                     FROM server_states  \
                    WHERE topic = 'WLM_FPFA_INDEXES'  \
                      AND current_state <> new_state \
                      AND server_name in ('${E_WLM_BATCH_SERVER_NAME_1}', '${E_WLM_BATCH_SERVER_NAME_2}')"
         rcloop2=$?

         if [[ $rcloop2 -eq 0 ]]; then
            sql_cnt_loop=$sql_cnt_loop+1
            if [[ ${E_WLM_SQL_RESULT} -eq 0 ]]; then
               Log "DJ Indexing has Completed..."
               rcloop2=0 # no rows - indexing has completed (not found in server_states table), return RC=0
               break     # exit from 2nd loop
            elif [[ ${E_WLM_SQL_RESULT} -gt 0 ]]; then
               sleep 1 # wait 1 sec then loop again
               continue  # record exists, continue monitoring indexing - loop again
            fi

         fi
      done

      rc=$rcloop2

   else
      rc=$rcloop1
   fi

exec_SQL()
{
   sql_Stmt=$1

   sql_Type=`echo $sql_Stmt | awk -F " " '{ printf toupper($1) }'`

   E_WLM_SQL_RESULT=`sqlplus -s /@${E_WLM_DB} <<!
      set pagesize 0 feedback off verify off heading off echo on
      whenever SQLERROR exit SQL.SQLCODE
      whenever OSERROR exit 9
      $sql_Stmt;
      commit;
   !`

   sql_RC=$?

   if [[ $sql_RC -eq 0 ]]; then

      str_Result=`echo $E_WLM_SQL_RESULT | grep SP2`  

      if [[ ${#str_Result} > 0 ]]; then
         sql_RC=57      # SQL Error
         sql_Code=0 
      else
         export E_WLM_SQL_RESULT
      fi
   else
      sql_Code=$sql_RC   # Store SQL.SQLCODE before overwriting

      if [[ $sql_RC -eq 9 ]]; then   # OSERROR
         sql_RC=91     
      else
         case $sql_Type in 
            INSERT) sql_RC=52 ;;
            UPDATE) sql_RC=53 ;;
            SELECT) sql_RC=54 ;;
            DELETE) sql_RC=56 ;;
            *) sql_RC=57 ;;
         esac
      fi
   fi

   if [[ $sql_RC -ne 0 ]]; then
      Log "Error in executing SQL Statement: $sql_Stmt "
      Log "SQL.SQLCODE=$sql_Code"
      Log "=====================================   ORACLE ERROR DESCRIPTION  ====================================="  
      Log "$E_WLM_SQL_RESULT"
      Log "======================================================================================================="
      Log "Returning with $sql_RC"

   fi

   return $sql_RC 
}

exec DBMS_SESSION.SESSION_TRACE_ENABLE;