DROP TABLE IF EXISTS t1;

DROP PROCEDURE IF EXISTS p1;

SET sql_mode=ORACLE;

CREATE TABLE t1 (a INT, b VARCHAR(32));

INSERT INTO t1 VALUES (10,'b0');

INSERT INTO t1 VALUES (11,'b1');

INSERT INTO t1 VALUES (12,'b2');

DELIMITER $$

CREATE PROCEDURE p1(pa INT, pb VARCHAR(32)) AS 

  CURSOR cur(va INT, vb VARCHAR(32)) IS

    SELECT a, b FROM t1 WHERE a=va AND b=vb;

BEGIN

  FOR rec IN cur(pa,pb)

  LOOP

    SELECT rec.a, rec.b;

  END LOOP;

END;

$$

DELIMITER ;

CALL p1(10,'B0');

CALL p1(11,'B1');

CALL p1(12,'B2');

CALL p1(12,'non-existing');

DROP TABLE t1;

DROP PROCEDURE p1;

+-------+-------+

| rec.a | rec.b |

+-------+-------+

|    10 | b0    |

+-------+-------+

+-------+-------+

| rec.a | rec.b |

+-------+-------+

|    11 | b1    |

+-------+-------+

+-------+-------+

| rec.a | rec.b |

+-------+-------+

|    12 | b2    |

+-------+-------+