Dynamic sized multiple occurrence data structure

["Mike Cunningham" <MCUNNING@xxxxxxx>]

Is there any trick available to create a multiple occurrence data
structure and define the size at run time? I have done some searching
but can't find anything that says it's possible. I did see how to create
a dynamic array but my application is used as a stored procedure that
returns a result set and so I can't use arrays. My procedure is called
from a web app and could return between 1 and 1,000 records in the
result set depending on the selection options used. I would prefer to
not have to allocate 1,000 records in the data structure if I only need
to return a much smaller number. Based on the parameters coming into the
procedure I know if I will be returning <30 or <100 or <400 or <1,000
 
Mike Cunningham
Pennsylvania College of Technology
www.pct.edu
mcunning@xxxxxxx