-
Notifications
You must be signed in to change notification settings - Fork 5
/
Copy pathsimple_test_pkg.pkb
124 lines (75 loc) · 2.18 KB
/
simple_test_pkg.pkb
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
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
create or replace package body simple_test_pkg
as
/*
Purpose: this is a simple test package
Remarks:
Date Who Description
---------- --- -------------------------------------
05.11.2020 MBR Created
*/
procedure do_something
as
begin
/*
Purpose: this procedure does something
Remarks:
Date Who Description
---------- --- -------------------------------------
05.11.2020 MBR Created
*/
-- TODO: add your own magic here...
null;
end do_something;
function get_something (p_id in number) return varchar2
as
l_returnvalue xy_customer.customer_name%type;
begin
/*
Purpose: this function returns something
Remarks:
Date Who Description
---------- --- -------------------------------------
05.11.2020 MBR Created
*/
l_returnvalue := customer_pkg.get_customer_name (p_customer_id => p_id);
return l_returnvalue;
end get_something;
procedure calculate_something
as
begin
/*
Purpose: this procedure calculates something
Remarks:
Date Who Description
---------- --- -------------------------------------
05.11.2020 MBR Created
*/
-- TODO: add your own magic here...
null;
end calculate_something;
procedure debug_something (p_value1 in number,
p_value2 in number)
as
l_scope logger_logs.scope%type := lower($$plsql_unit) || '.' || 'debug_something';
l_params logger.tab_param;
begin
/*
Purpose: this procedure execution is logged
Remarks:
Date Who Description
---------- --- -------------------------------------
05.11.2020 MBR Created
*/
logger.append_param(l_params, 'p_value1', p_value1);
logger.append_param(l_params, 'p_value2', p_value2);
logger.log('START', l_scope, null, l_params);
-- TODO: add your own magic here...
null;
logger.log('END', l_scope);
exception
when others then
logger.log_error('Unhandled Exception', l_scope, null, l_params);
raise;
end debug_something;
end simple_test_pkg;
/