Debian Codegraph @

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

raw
1 DELIMITER $$;
2 CREATE PACKAGE pkg AS
3 FUNCTION f1 RETURN INT;
4 END;
5 $$
6 CREATE PACKAGE BODY pkg AS
7 vc INT := 0;
8 FUNCTION f1 RETURN INT AS
9 CURSOR cur IS SELECT 1 AS c FROM DUAL;
10 BEGIN
11 OPEN cur;
12 FETCH cur INTO vc; -- SHOW CODE should display vc with a "PACKAGE_BODY" prefix
13 CLOSE cur;
14 RETURN vc;
15 END;
16 BEGIN
17 DECLARE
18 CURSOR cur IS SELECT 1 AS c FROM DUAL;
19 BEGIN
20 OPEN cur;
21 FETCH cur INTO vc; -- SHOW CODE should display vc without a prefix
22 CLOSE cur;
23 END;
24 END;
25 $$
26 DELIMITER ;$$