multiple row output from procedure

I need to create a procedure (or package?) that retrieves multiple rows from a table,
i.e.
CREATE PROCEDURE procname (first OUT VARCHAR2, last OUT VARCHAR2 ) AS
BEGIN
  SELECT firstname, lastname
  INTO first, last
  FROM tablename
END; There will be a multiple row answer, but how do I handle the response? What datatypes should the outgoing variables be? Can I call the procedure in a single sql line?

/Fredrik Received on Tue Aug 04 1998 - 04:04:05 CDT