set sql_mode='oracle';

delimiter //;

CREATE PROCEDURE sp1 AS

CURSOR n3 is SELECT 1;

CURSOR c3 (t1 int, t2 int, t3 int) is SELECT 5;

d int := 10;

o1 row(id INT);

u1 row(id INT);

g2 row(a int, b int, c int, d int ); 

BEGIN

END;

//

--error 1241

CALL sp1//

set sql_mode='oracle';

CREATE PROCEDURE sp1 AS

CURSOR n3 is SELECT 1;

CURSOR c3 (t1 int, t2 int, t3 int) is SELECT 5;

d int := 10;

o1 row(id INT);

u1 row(id INT);

g2 row(a int, b int, c int, d int ); 

BEGIN

END;

//

CALL sp1//

ERROR 21000: Operand should contain 4 column(s)

CREATE or replace PROCEDURE sp1 AS

CURSOR n3 is SELECT 1;

CURSOR c3 (t1 int, t2 int, t3 int) is SELECT 5;

o1 row(id INT);

u1 row(id INT);

g2 row(a int, b int, c int, d int ); 

BEGIN

END;

//

CALL sp1//

CREATE or replace PROCEDURE sp1 AS

CURSOR n3 is SELECT 1;

CURSOR c3 (t1 int, t2 int, t3 int) is SELECT 5;

d1 int := 10;

d2 int := 10;

o1 row(id INT);

u1 row(id INT);

g2 row(a int, b int, c int, d int ); 

BEGIN

END;

//

CALL sp1//

mysqltest: At line 47: query 'CALL sp1' failed: 1241: Operand should contain 1 column(s)