SET sql_mode=ORACLE;

DROP PROCEDURE IF EXISTS p1;

DELIMITER $$

CREATE PROCEDURE p1 AS

  CURSOR cur IS SELECT 10 as a, 'b1' AS b;

  rec cur%ROWTYPE;

BEGIN

  SELECT 10,'b1' INTO rec.a, rec.b;

  SELECT rec.a, rec.b;

END;

$$

DELIMITER ;

CALL p1;

SET sql_mode=ORACLE;

DROP TABLE IF EXISTS t1;

DROP PROCEDURE IF EXISTS p1;

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

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

DELIMITER $$

CREATE PROCEDURE p1 AS

  CURSOR cur IS SELECT * FROM t1;

  rec t1%ROWTYPE;

BEGIN

  SELECT 10,'b1' INTO rec.a, rec.b;

  SELECT rec.a, rec.b;

END;

$$

DELIMITER ;

CALL p1;