FOR LOOP with cursor name changed to the FOR DO with CURSOR.

Oracle:

DECLARE 
CURSOR c1 (para INT) IS SELECT last_name, job_id FROM employees 
 WHERE job_id LIKE '%CLERK%' AND manager_id > 120; 
 BEGIN 
 <<l_name>> 
   FOR item IN c1(10) 
   LOOP 
       DBMS_OUTPUT.PUT_LINE (item.full_name); 
   END LOOP l_name; 
 END;

HiRDB:

CREATE PROCEDURE for_loop_cusor() 
BEGIN 
 DECLARE para INT;
 DECLARE C1 CURSOR FOR SELECT last_name, job_id FROM employees 
     WHERE job_id LIKE '%CLERK%' AND manager_id > 120; 
 SET para = 10;
 l_name: 
 FOR item AS C1 CURSOR FOR SELECT last_name, job_id FROM employees 
     WHERE job_id LIKE '%CLERK%' AND manager_id > 120 
 DO 
    WRITE LINE (item.full_name); 
 END FOR l_name; 
END;
END_PROC