Oracle 11g: les curseurs !!

SET SERVEROUTPUT ON;
DECLARE
    v_emp  scott.emp%rowtype;
    CURSOR c_emp IS
    SELECT ename, job
      FROM scott.emp
     WHERE job = 'SALESMAN';
BEGIN
    OPEN c_emp;
    LOOP
        FETCH c_emp INTO v_emp.ename, v_emp.job;
        EXIT WHEN c_emp%NOTFOUND;
        INSERT INTO ta_table values(a,b,c,v_emp.ename, v_emp.job); 
    END LOOP;
    CLOSE c_emp;
    COMMIT;
END