Debian Codegraph @

mysql-test/suite/compat/oracle/t/sp-cursor-pkg-02.inc

raw
1 # Mixing a package body variable and a local variable in the same FETCH.
2 DELIMITER $$;
3 CREATE PACKAGE pkg AS
4 FUNCTION f1 RETURN TEXT;
5 END;
6 $$
7 CREATE PACKAGE BODY pkg AS
8 vc1 INT := 0;
9 FUNCTION f1 RETURN TEXT AS
10 CURSOR cur IS SELECT 1 AS c1, 2 AS c2 FROM DUAL;
11 vc2 INT := 0;
12 BEGIN
13 OPEN cur;
14 FETCH cur INTO vc1, vc2;
15 CLOSE cur;
16 RETURN vc1 || ' ' || vc2;
17 END;
18 END;
19 $$
20 DELIMITER ;$$