>Hi,
> I would like to import a huge table for aggregate function (about 17,000 records). For better performance, i try to store it into array. I get an error "too many variable". Any ideas to solve it?
>
>Thank you

John,
17,000 is puny - I've done aggregates in cursors with over a million records and it works fine.

HTH,