mysql-test/suite/compat/oracle/t/sp-cursor-pkg-03.inc
raw| 1 | # Fetching into a PACKAGE BODY variable of the ROW type |
| 2 | DELIMITER $$; |
| 3 | CREATE PACKAGE pkg AS |
| 4 | FUNCTION f1 RETURN TEXT; |
| 5 | END; |
| 6 | $$ |
| 7 | CREATE PACKAGE BODY pkg AS |
| 8 | vc ROW(p1 INT, p2 INT); |
| 9 | FUNCTION f1 RETURN TEXT AS |
| 10 | CURSOR cur IS SELECT 1 AS c1, 2 AS c2 FROM DUAL; |
| 11 | BEGIN |
| 12 | OPEN cur; |
| 13 | FETCH cur INTO vc; |
| 14 | CLOSE cur; |
| 15 | RETURN vc.p1 || ' ' || vc.p2; |
| 16 | END; |
| 17 | END; |
| 18 | $$ |
| 19 | DELIMITER ;$$ |