PROCEDURE get_details IS

iLoop number := 1;

 CURSOR c is
	
       SELECT FULL_NAME
       FROM GRP_EMPLOYEE
       WHERE  EMPLOYEE_NUMBER = :USER_ID;

BEGIN
	
  OPEN c;
 	
LOOP
	
  message(iLoop);
	
    	FETCH c into :FULL_NAME;  
    	 	       
  message(:FULL_NAME); 
  
     	 iLoop := iLoop + 1;
           
		EXIT WHEN iLoop = 6;
			NEXT_RECORD;
  END LOOP;        
  
CLOSE c;

END;

Loop:        Result:

1            Full_Name
2            Empty
3            Empty
4            Empty