01-15-2008
33,
0
Join Date: Jul 2007
Last Activity: 25 November 2010, 5:22 AM EST
Posts: 33
Thanks Given: 0
Thanked 0 Times in 0 Posts
How to declare an array to take more than 10,000 characters
Hi Guys
Need some help
I am reading the string values from the text files into the shell script and had them feed into array
I have declared an associative array as
TYPE t_user_id_tab IS TABLE OF VARCHAR2(3000);\n
my_user_id t_user_id_tab;\n
varchar2 is limiting me to take only 32760 characters
but I have a text files which has more than 1100 users with length of each user id is 8
1100* 8 = 8800 + the '',sapces
so I am looking around 10,000 characters is there a way that I can declare the array of string to take 10,00 characters
Thanks in advance
Pinky