DECLARE

DECLARE
   CURSOR c_user
   IS
      select * from COP_COP_SEL_FAE;
BEGIN
 

      FOR r_user IN c_user
      LOOP
        insert into user_role
  (USER_ID,
   ROLE_ID,
   CREATION_DATE,
   CREATED_BY,
   LAST_UPDATE_DATE,
   LAST_UPDATED_BY)
values
  (r_user.person_id,
   5,
   to_date('04-06-2015 14:30:21', 'dd-mm-yyyy hh24:mi:ss'),
   -1,
   to_date('04-06-2015 14:30:21', 'dd-mm-yyyy hh24:mi:ss'),
   -1);
      END LOOP;
END;