Shell Programming and Scripting

 {
    sqlplus -s /nolog << EOFSQL
        set feedback off
        set head off
        set verify off
        set linesize 5000
        @${DIR_COMMON}/ADMIN.conn
        
        select 
            'array_SQLValues1[' ||to_number(rownum-1)|| ']="' ||FieldValule1|| '";'
          ||'array_SQLValues2[' ||to_number(rownum-1)|| ']="' ||FieldValue2|| '";'
        from
            THIS_TABLE a,
EOFSQL
    } | while read line
    do
        if $DIR_CONTROL_SUBROUTINES/SUB_chk_sql.ksh ${line:-BLANK} "Retrieve_File_List"
        then {
            if printf "${line:-BLANK}" | grep = > /dev/null
            then {
                ######################################
                # use "eval" to initialize the arrays
                # take a count of the records found
                #######################################
                eval ${line} && fileCounter=$((${fileCounter}+1)) 
            }
            fi
        }
        fi
    done
}