Debian Codegraph @

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 ;$$