SELECT Multiple Rows of a Table INTO a PL/Sql TableRecord Without Using Cursor

I wonder if it is possible to SELECT directly multiple rows of a table into a PL/Sql table record without using cursor? Here is a simple example:

DECLARE
  TYPE PeriodRecTabType IS TABLE OF Period%ROWTYPE     INDEX BY BINARY_INTEGER;
  PeriodRecTab PeriodRecTabType;
  IndexVar BINARY_INTEGER := 1;
BEGIN
  SELECT * INTO PeriodRecTab(IndexVar)
    FROM Period;
  EXCEPTION
......
......

END; When I run it I get the ORA-01422, exact fetch returns more than requested number of rows.

Is it possible at all? any workaround?

Thanks,
Adam Tadj Received on Thu Jul 22 1999 - 13:40:28 CDT