UNIX for Dummies Questions & Answers

I am sending the data in userfile and colfile from ksh script to pl/sql script
linto an array with this command

grep '[a-zA-Z]' $userfile |awk '{print "my_user_id("FNR") := '$SQL_QUOTE'"$1"'$SQL_QUOTE';"}' >> $SQL_TEMP_FILE

grep '^[0-9]\{1,10\}$' $colfile | awk '{print "my_col_id("NR") := "$1";"}' >> $SQL_TEMP_FILE


SQL_TEMP_FILE is the pl/sql script file

userfile has the below data
pinky
dolly

colfile has the below data
1198
1134
1165
1135

in pl/sql script with this command
grep '[a-zA-Z]' $userfile |awk '{print "my_user_id("FNR") := '$SQL_QUOTE'"$1"'$SQL_QUOTE';"}' >> $SQL_TEMP_FILE
I am able to send as


my_user_id(1) := 'pinky'
my_user_id(2) := 'dolly'

with this command
grep '^[0-9]\{1,10\}$' $colfile | awk '{print "my_col_id("NR") := "$1";"}' >> $SQL_TEMP_FILE
I am able to send as
my_col_id(1) := 1198;
my_col_id(2) := 1134;
my_col_id(3) := 1165;
my_col_id(4) := 1135;

but I am problem is if userfile has 1000 records
and colfile has 1000 records it will fill up my SQL_TEMP_FILE

in my pl/sql script I declared array as

TYPE t_user_id_tab IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
my_user_id t_user_id_tab;

so any one can suggest me any command to send like this

my_user_id := t_user_id_tab('pinky','dolly');
so that it looks better for 1000 records

thanks in advance
pinky










echo $SQL_A > $SQL_TEMP_FILE
grep '[a-zA-Z]' $userfile |awk '{print "my_user_id("FNR") := '$SQL_QUOTE'"$1"'$SQL_QUOTE';"}' >> $SQL_TEMP_FILE
grep '^[0-9]\{1,10\}$' $colfile | awk '{print "my_col_id("NR") := "$1";"}' >> $SQL_TEMP_FILE
echo $SQL_C >> $SQL_TEMP_FILE