You can retrieve multiple rows with a single select into statement by using arrays as output host variables. If no errors or warnings occur, all selected rows are returned up to the limit of the length of the arrays. However, if a truncation or conversion warning or error occurs, rows are returned only up to and including the row where the error or warning occurred. To ensure receiving all rows, use a cursor and continue fetching until there are no more rows.
