The following Array (file_var) is declared in a shell script.
set -A file_var
${file_var[0]}
${file_var[1]}
${file_var[2]}
${file_var[3]}
${file_var[4]}
${file_var[5]}
${file_var[6]}
${file_var[7]}
${file_var[8]}
${file_var[9]}
set -A file_var `$ORACLE_BIN/sqlplus -s $UN/$PW@$SID @pass_out.sql

The pass_out.sql script returns more than 1 record. I want to process all the records returned by the sql in a loop and then exit.

Any help is appreciated

Thanks

The length of an array can be determined using...So you would want to implement something like this...HTH