Repository navigation
Expand file tree
/
Copy pathtest_package-b.sql
More file actions
76 lines (61 loc) · 1.76 KB
/
Copy pathtest_package-b.sql
File metadata and controls
76 lines (61 loc) · 1.76 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
CREATE OR REPLACE PACKAGE BODY test_package AS
FUNCTION out_integers(p_integer IN INTEGER)
RETURN tt_integers IS
BEGIN
RETURN tt_integers(1, 2, p_integer);
END;
FUNCTION return_record
RETURN tr_rec IS
vr_rec tr_rec;
BEGIN
vr_rec.int_1 := 1;
vr_rec.int_2 := 2;
vr_rec.int_3 := 3;
vr_rec.int_4 := 4;
RETURN vr_rec;
END return_record;
FUNCTION return_table_of_recs
RETURN tt_rec IS
vt_rec tt_rec;
BEGIN
FOR v_i IN 1 .. 2 LOOP
vt_rec(v_i) := return_record;
END LOOP;
RETURN vt_rec;
END;
PROCEDURE simple_procedure IS
BEGIN
NULL;
END simple_procedure;
FUNCTION simple_function(p_int IN INTEGER)
RETURN INTEGER IS
BEGIN
RETURN p_int * p_int;
END simple_function;
FUNCTION compute_agg_length(pt_stringlist IN tt_stringlist)
RETURN INTEGER IS
v_result INTEGER := 0;
BEGIN
FOR i IN pt_stringlist.FIRST .. pt_stringlist.LAST LOOP
v_result := v_result + LENGTH(pt_stringlist(i));
END LOOP;
RETURN v_result;
END compute_agg_length;
FUNCTION compute_rec_product(pr_rec IN tr_rec)
RETURN INTEGER IS
BEGIN
RETURN pr_rec.int_1 * pr_rec.int_2 * pr_rec.int_3 * pr_rec.int_4;
END compute_rec_product;
FUNCTION compute_rec_table(pt_rec IN tt_rec)
RETURN INTEGER IS
v_result INTEGER := 0;
BEGIN
FOR i IN pt_rec.FIRST .. pt_rec.LAST LOOP
v_result := v_result + compute_rec_product(pr_rec => pt_rec(i));
END LOOP;
RETURN v_result;
EXCEPTION
WHEN NO_DATA_FOUND THEN
RETURN pt_rec.COUNT;
END compute_rec_table;
END test_package;