Repository navigation
Expand file tree
/
Copy pathtest_out_params-b.sql
More file actions
242 lines (193 loc) · 7.82 KB
/
Copy pathtest_out_params-b.sql
File metadata and controls
242 lines (193 loc) · 7.82 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
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
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
-- noinspection SqlDeprecateType
CREATE OR REPLACE PACKAGE BODY test_out_params AS
-- 0 placeholder for procedures with no arguments -- ------||------
-- 1 VARCHAR2, VARCHAR, STRING -- str
PROCEDURE out_varchar2(p_param OUT VARCHAR2) IS
BEGIN
p_param := test_return.ret_varchar2;
END out_varchar2;
PROCEDURE out_varchar(p_param OUT VARCHAR) IS
BEGIN
p_param := test_return.ret_varchar;
END out_varchar;
PROCEDURE out_string(p_param OUT STRING) IS
BEGIN
p_param := test_return.ret_string;
END out_string;
-- 2 NUMBER, INTEGER, SMALLINT, REAL, FLOAT, DECIMAL -- float
PROCEDURE out_number(p_param OUT NUMBER) IS
BEGIN
p_param := test_return.ret_number;
END out_number;
PROCEDURE out_integer(p_param OUT INTEGER) IS
BEGIN
p_param := test_return.ret_integer;
END out_integer;
PROCEDURE out_smallint(p_param OUT SMALLINT) IS
BEGIN
p_param := test_return.ret_smallint;
END out_smallint;
PROCEDURE out_real(p_param OUT REAL) IS
BEGIN
p_param := test_return.ret_real;
END out_real;
PROCEDURE out_float(p_param OUT FLOAT) IS
BEGIN
p_param := test_return.ret_float;
END out_float;
PROCEDURE out_numeric(p_param OUT NUMERIC) IS
BEGIN
p_param := test_return.ret_numeric;
END out_numeric;
PROCEDURE out_decimal(p_param OUT DECIMAL) IS
BEGIN
p_param := test_return.ret_decimal;
END out_decimal;
-- 3 BINARY_INTEGER, PLS_INTEGER, POSITIVE, NATURAL -- int
PROCEDURE out_binary_integer(p_param OUT BINARY_INTEGER) IS
BEGIN
p_param := test_return.ret_binary_integer;
END;
PROCEDURE out_pls_integer(p_param OUT PLS_INTEGER) IS
BEGIN
p_param := test_return.ret_pls_integer;
END;
PROCEDURE out_positive(p_param OUT POSITIVE) IS
BEGIN
p_param := test_return.ret_positive;
END;
PROCEDURE out_natural(p_param OUT NATURAL) IS
BEGIN
p_param := test_return.ret_natural;
END;
-- 8 LONG ?CLOB? -- str
PROCEDURE out_clob(p_param OUT CLOB) IS
BEGIN
p_param := test_return.ret_clob;
END;
PROCEDURE out_long(p_param OUT LONG) IS
BEGIN
p_param := test_return.ret_long;
END;
-- 11 ROWID -- str
PROCEDURE out_rowid(p_param OUT ROWID) IS
BEGIN
p_param := test_return.ret_rowid;
END;
-- 12 DATE -- datetime.datetime
PROCEDURE out_date(p_param OUT DATE) IS
BEGIN
p_param := test_return.ret_date;
END;
-- 23 RAW -- bytes
PROCEDURE out_raw(p_param OUT RAW) IS
BEGIN
p_param := test_return.ret_raw;
END;
-- 24 LONG RAW -- bytes
PROCEDURE out_long_raw(p_param OUT LONG RAW) IS
BEGIN
p_param := test_return.ret_long_raw;
END;
-- 58 OPAQUE TYPE -- ??? XMLType OUT Oracle
--PROCEDURE out_binary_integer(p_param OUT BINARY_INTEGER);
-- 96 CHAR (ANSI FIXED CHAR), CHARACTER -- str
PROCEDURE out_char(p_param OUT CHAR) IS
BEGIN
p_param := test_return.ret_char;
END;
PROCEDURE out_character(p_param OUT CHARACTER) IS
BEGIN
p_param := test_return.ret_character;
END;
-- 106 MLSLABEL -- ??? only backwards compatibility ???
--PROCEDURE out_binary_integer(p_param OUT BINARY_INTEGER);
-- 121 OBJECT -- cx_Oracle.Object ???
--PROCEDURE out_binary_integer(p_param OUT BINARY_INTEGER);
-- 122 NESTED TABLE -- list
PROCEDURE out_nested(p_param OUT test_return.tt_nested) IS
BEGIN
p_param := test_return.ret_nested;
END out_nested;
PROCEDURE out_nested_of_records(p_param OUT test_return.tt_nested_of_records) IS
BEGIN
p_param := test_return.ret_nested_of_records;
END out_nested_of_records;
PROCEDURE out_nested_of_nested(p_param OUT test_return.tt_nested_of_nested) IS
BEGIN
p_param := test_return.ret_nested_of_nested;
END out_nested_of_nested;
PROCEDURE out_nested_of_plsql_table(p_param OUT test_return.tt_nested_of_plsql_table) IS
BEGIN
p_param := test_return.ret_nested_of_plsql_table;
END out_nested_of_plsql_table;
PROCEDURE out_nested_of_record_of_nested(p_param OUT test_return.tt_nested_of_record_of_nested) IS
BEGIN
p_param := test_return.ret_nested_of_record_of_nested;
END out_nested_of_record_of_nested;
-- 123 VARRAY -- list
PROCEDURE out_varray(p_param OUT test_return.tt_varray) IS
BEGIN
p_param := test_return.ret_varray;
END out_varray;
PROCEDURE out_varray_of_nested(p_param OUT test_return.tt_varray_of_nested) IS
BEGIN
p_param := test_return.ret_varray_of_nested;
END out_varray_of_nested;
PROCEDURE out_varray_of_plsql_table(p_param OUT test_return.tt_varray_of_plsql_table) IS
BEGIN
p_param := test_return.ret_varray_of_plsql_table;
END out_varray_of_plsql_table;
-- 178 TIME -- datetime.datetime
--PROCEDURE out_binary_integer(p_param OUT BINARY_INTEGER);
-- 179 TIME WITH TIME ZONE -- datetime.datetime
--PROCEDURE out_binary_integer(p_param OUT BINARY_INTEGER);
-- 180 TIMESTAMP -- datetime.datetime
PROCEDURE out_timestamp(p_param OUT TIMESTAMP) IS
BEGIN
p_param := test_return.ret_timestamp;
END out_timestamp;
-- 181 TIMESTAMP WITH TIME ZONE -- datetime.datetime
--PROCEDURE out_binary_integer(p_param OUT BINARY_INTEGER);
-- 231 TIMESTAMP WITH LOCAL TIME ZONE -- datetime.datetime
--PROCEDURE out_binary_integer(p_param OUT BINARY_INTEGER);
-- 250 PL/SQL RECORD -- tuple - namedtuple
PROCEDURE out_record(p_param OUT test_return.tr_record) IS
BEGIN
p_param := test_return.ret_record;
END;
PROCEDURE out_record_of_records(p_param OUT test_return.tr_record_of_records) IS
BEGIN
p_param := test_return.ret_record_of_records;
END out_record_of_records;
PROCEDURE out_record_of_nested(p_param OUT test_return.tr_record_of_nested) IS
BEGIN
p_param := test_return.ret_record_of_nested;
END out_record_of_nested;
PROCEDURE out_record_of_plsql_table(p_param OUT test_return.tr_record_of_plsql_table) IS
BEGIN
p_param := test_return.ret_record_of_plsql_table;
END out_record_of_plsql_table;
-- 251 PL/SQL TABLE -- mapping
PROCEDURE out_plsql_table(p_param OUT test_return.tt_plsql_table) IS
BEGIN
p_param := test_return.ret_plsql_table;
END out_plsql_table;
PROCEDURE out_plsql_table_of_records(p_param OUT test_return.tt_plsql_table_of_records) IS
BEGIN
p_param := test_return.ret_plsql_table_of_records;
END out_plsql_table_of_records;
PROCEDURE out_plsql_table_of_nested(p_param OUT test_return.tt_plsql_table_of_nested) IS
BEGIN
p_param := test_return.ret_plsql_table_of_nested;
END out_plsql_table_of_nested;
PROCEDURE out_plsql_table_of_plsql_table(p_param OUT test_return.tt_plsql_table_of_plsql_table) IS
BEGIN
p_param := test_return.ret_plsql_table_of_plsql_table;
END out_plsql_table_of_plsql_table;
-- 252 PL/SQL BOOLEAN -- bool
PROCEDURE out_bool(p_param OUT BOOLEAN) IS
BEGIN
p_param := test_return.ret_bool;
END;
END test_out_params;