limit of 100 fields shown in varrays

[jdorlon]

Hello,

I have the following objects in my database.

Code: Select all

CREATE OR REPLACE TYPE ARRAY_OF_110 AS VARRAY (110) of NUMBER
/

create table tbl_with_array_of_110
 (col1 number,
  array_of_110_col array_of_110);
  
insert into tbl_with_array_of_110
(col1, array_of_110_col)
values
(1, array_of_110(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,
25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,
51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,
77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,
102,103,104,105,106,107,108,109,110));
                         
commit;

Now, when I do a "select * from tbl_with_array_of_110" in a TSmartQuery attached to a TDBGrid, I only see 100 of the 110 array values.

Is this an ODAC limitation? Is there any way that I can increase the limit?

Thanks

-John

[Plash]

You can assing another value to the MaxArrayItem constant from the MemData unit.