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;