Hey guys, I have created the following procedure but the problem is that the SELECT INTO will not work if more than one row is selected I was just wondering if there is a way round this problem? Thanks.

Code:
CREATE OR REPLACE PROCEDURE HOURS IS
HOURVAR NUMBER;
 BEGIN
 SELECT HOURS
 INTO HOURVAR
 FROM ADMIN
THEN
  IF HOURVAR > 250
   UPDATE SECTION
   SET RATE = 'RRC'
END IF
END;