@delimiter $;
CREATE OR REPLACE PROCEDURE proc3()
specific proc3
BEGIN
  DECLARE c1 CHAR(6);
  DECLARE c2 VARCHAR(12);
  DECLARE c3 VARCHAR(12);
  DECLARE c4 CHAR(3);
  DECLARE c5 DECIMAL(9,2);
  DECLARE c6 CHAR(1);
  DECLARE sqlstate CHAR(5);
  DECLARE cr cursor FOR
    SELECT empno,firstnme,lastname,workdept,salary,sex FROM employee;
  OPEN cr;
  fetch FROM cr INTO c1,c2,c3,c4,c5,c6;
  whileloop:
  while sqlstate='00000' do
    IF c6='F' THEN 
       INSERT INTO females(empno,firstnme,lastname,workdept,salary,sex) VALUES(c1,c2,c3,c4,c5,c6);
    ELSE
       fetch FROM cr INTO c1,c2,c3,c4,c5,c6;
       ITERATE whileloop; 
       INSERT INTO males(empno,firstnme,lastname,workdept,salary,sex) VALUES(c1,c2,c3,c4,c5,c6);
    END IF;
    fetch FROM cr INTO c1,c2,c3,c4,c5,c6;
  END while;
  close cr;
END$
@delimiter ;$
CALL proc3();
SELECT * FROM males;
SELECT * FROM females;

IF c6='F' THEN 
           INSERT INTO females(empno,firstnme,lastname,workdept,salary,sex) VALUES(c1,c2,c3,c4,c5,c6);
        ELSE
           fetch FROM cr INTO c1,c2,c3,c4,c5,c6;
           ITERATE whileloop; 
           INSERT INTO males(empno,firstnme,lastname,workdept,salary,sex) VALUES(c1,c2,c3,c4,c5,c6);
        END IF;