1--
2-- PORTALS_P2
3--
4
5BEGIN;
6
7DECLARE foo13 CURSOR FOR
8   SELECT * FROM onek WHERE unique1 = 50;
9
10DECLARE foo14 CURSOR FOR
11   SELECT * FROM onek WHERE unique1 = 51;
12
13DECLARE foo15 CURSOR FOR
14   SELECT * FROM onek WHERE unique1 = 52;
15
16DECLARE foo16 CURSOR FOR
17   SELECT * FROM onek WHERE unique1 = 53;
18
19DECLARE foo17 CURSOR FOR
20   SELECT * FROM onek WHERE unique1 = 54;
21
22DECLARE foo18 CURSOR FOR
23   SELECT * FROM onek WHERE unique1 = 55;
24
25DECLARE foo19 CURSOR FOR
26   SELECT * FROM onek WHERE unique1 = 56;
27
28DECLARE foo20 CURSOR FOR
29   SELECT * FROM onek WHERE unique1 = 57;
30
31DECLARE foo21 CURSOR FOR
32   SELECT * FROM onek WHERE unique1 = 58;
33
34DECLARE foo22 CURSOR FOR
35   SELECT * FROM onek WHERE unique1 = 59;
36
37DECLARE foo23 CURSOR FOR
38   SELECT * FROM onek WHERE unique1 = 60;
39
40DECLARE foo24 CURSOR FOR
41   SELECT * FROM onek2 WHERE unique1 = 50;
42
43DECLARE foo25 CURSOR FOR
44   SELECT * FROM onek2 WHERE unique1 = 60;
45
46FETCH all in foo13;
47
48FETCH all in foo14;
49
50FETCH all in foo15;
51
52FETCH all in foo16;
53
54FETCH all in foo17;
55
56FETCH all in foo18;
57
58FETCH all in foo19;
59
60FETCH all in foo20;
61
62FETCH all in foo21;
63
64FETCH all in foo22;
65
66FETCH all in foo23;
67
68FETCH all in foo24;
69
70FETCH all in foo25;
71
72CLOSE foo13;
73
74CLOSE foo14;
75
76CLOSE foo15;
77
78CLOSE foo16;
79
80CLOSE foo17;
81
82CLOSE foo18;
83
84CLOSE foo19;
85
86CLOSE foo20;
87
88CLOSE foo21;
89
90CLOSE foo22;
91
92CLOSE foo23;
93
94CLOSE foo24;
95
96CLOSE foo25;
97
98END;
99