I will first off admit - this is for school. I cannot figure out for the life of me why it won't work. I'm not expecting anyone to give me the answer (but would gladly take it!) but rather am looking for someone to point me in the right direction. I am to write a stored procedure that displays the first name concatenated with the last name from a particular table. I am to use an implicit FOR loop. Now I wrote a cursor to get the data and that works fine: DECLARE CURSOR NNAME IS SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME FROM CH10EMPLOYEE; BEGIN FOR RCLIENT IN NNAME LOOP DBMS_OUTPUT.PUT_LINE(RCLIENT.FIRST_NAME||' '||RCLIENT.LAST_NAME); END LOOP; END; / I cannot, however, for the life of me, get this to develop into a procedure. I've never written one before. Here is what I am trying, but it is not working: SET SERVEROUTPUT ON; EXEC DBMS_OUTPUT.ENABLE(1000000); CREATE OR REPLACE PROCEDURE GETEMPLOYEES() ( AS (DECLARE CURSOR NNAME IS SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME FROM CH10EMPLOYEE); BEGIN FOR RCLIENT IN NNAME LOOP DBMS_OUTPUT.PUT_LINE(RCLIENT.FIRST_NAME||' '||RCLIENT.LAST_NAME); END LOOP; END; / ANY help would be GREATLY appreciated! Thanks!

HI TEST: FOR RCLIENT IN (SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAMEFROM CH10EMPLOYEE;) LOOP dbms_output.put_line( RCLIENT.FIRST_NAME||' '||RCLIENT.LAST_NAME); END LOOP; Regards, Oscar.