Regardless of whether you retrieve one row or multiple rows, when you retrieve data into a reference or array variable, the select statement must see the individual attributes of the variable rather than the variable as a whole.