Out of memory message

[AM Matula <amatula@OIT.UMASS.EDU>]

-- - -- - -- - -- - -- - -- - -- - -- - -- - -- - --
Anne-Marie Matula
Student Information System Project
Office of Information Technologies
University of Massachusetts
740 N. Pleasant St
OIT-LGRC A247
Amherst, MA  01003-9306
Phone: 413/577-0685
Fax: 413/545-2150

Hi all

I have a SQR that is aborting with the out of memory error.  What's
distressing
is it aborts during execution of the first procedure!

The first procedure simply:
1 extracts all records from a table
2 formats name (closed procedure calls)
3 stores data from the table in an array (initialized at a size of 250,000

This SQR ran fine when 4,000 records were extracted.  Now 225,000 records
are
being extracted.  I use about 6 arrays all with initial sizes between 100-
250K.  They were even larger before the "out of memory" message; I thought
perhaps decreasing the size might resolve this but it didn't.

Any suggestions for resolving?  I know I could decrease the # of records
processed at one time but I would rather not pursue that unless it is
absolutely necessary.

Thank you in advance!!
Anne-Marie

PS Please respond to me (cc line) at amatula@oit.umass.edu as I get this in
digest format.