Repository navigation
Expand file tree
/
Copy pathtest_in_params-h.sql
More file actions
121 lines (72 loc) · 4.55 KB
/
Copy pathtest_in_params-h.sql
File metadata and controls
121 lines (72 loc) · 4.55 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
CREATE OR REPLACE PACKAGE test_in_params AS
-- 0 placeholder for procedures with no arguments -- ------||------
-- 1 VARCHAR2, VARCHAR, STRING -- str
PROCEDURE in_varchar2(p_param IN VARCHAR2);
PROCEDURE in_varchar(p_param IN VARCHAR);
PROCEDURE in_string(p_param IN STRING);
-- 2 NUMBER, INTEGER, SMALLINT, REAL, FLOAT, DECIMAL -- float
PROCEDURE in_number(p_param IN NUMBER);
PROCEDURE in_integer(p_param IN INTEGER);
PROCEDURE in_smallint(p_param IN SMALLINT);
PROCEDURE in_real(p_param IN REAL);
PROCEDURE in_float(p_param IN FLOAT);
PROCEDURE in_numeric(p_param IN NUMERIC);
PROCEDURE in_decimal(p_param IN DECIMAL);
-- 3 BINARY_INTEGER, PLS_INTEGER, POSITIVE, NATURAL -- int
PROCEDURE in_binary_integer(p_param IN BINARY_INTEGER);
PROCEDURE in_pls_integer(p_param IN PLS_INTEGER);
PROCEDURE in_positive(p_param IN POSITIVE);
PROCEDURE in_natural(p_param IN NATURAL);
-- 8 LONG ?CLOB? -- str
PROCEDURE in_clob(p_param IN CLOB);
PROCEDURE in_long(p_param IN LONG);
-- 11 ROWID -- str
PROCEDURE in_rowid(p_param IN ROWID);
-- 12 DATE -- datetime.datetime
PROCEDURE in_date(p_param IN DATE);
-- 23 RAW -- bytes
PROCEDURE in_raw(p_param IN RAW);
-- 24 LONG RAW -- bytes
PROCEDURE in_long_raw(p_param IN LONG RAW);
-- 58 OPAQUE TYPE -- ??? XMLType in Oracle
--PROCEDURE in_binary_integer(p_param IN BINARY_INTEGER);
-- 96 CHAR (ANSI FIXED CHAR), CHARACTER -- str
PROCEDURE in_char(p_param IN CHAR);
PROCEDURE in_character(p_param IN CHARACTER);
-- 106 MLSLABEL -- ??? only backwards compatibility ???
--PROCEDURE in_binary_integer(p_param IN BINARY_INTEGER);
-- 121 OBJECT -- cx_Oracle.Object ???
--PROCEDURE in_binary_integer(p_param IN BINARY_INTEGER);
-- 122 NESTED TABLE -- list
PROCEDURE in_nested(p_param IN test_return.tt_nested);
PROCEDURE in_nested_of_records(p_param IN test_return.tt_nested_of_records);
PROCEDURE in_nested_of_nested(p_param IN test_return.tt_nested_of_nested);
PROCEDURE in_nested_of_plsql_table(p_param IN test_return.tt_nested_of_plsql_table);
PROCEDURE in_nested_of_record_of_nested(p_param IN test_return.tt_nested_of_record_of_nested);
-- 123 VARRAY -- list
PROCEDURE in_varray(p_param IN test_return.tt_varray);
PROCEDURE in_varray_of_nested(p_param IN test_return.tt_varray_of_nested);
PROCEDURE in_varray_of_plsql_table(p_param IN test_return.tt_varray_of_plsql_table);
-- 178 TIME -- datetime.datetime
--PROCEDURE in_binary_integer(p_param IN BINARY_INTEGER);
-- 179 TIME WITH TIME ZONE -- datetime.datetime
--PROCEDURE in_binary_integer(p_param IN BINARY_INTEGER);
-- 180 TIMESTAMP -- datetime.datetime
PROCEDURE in_timestamp(p_param IN TIMESTAMP);
-- 181 TIMESTAMP WITH TIME ZONE -- datetime.datetime
--PROCEDURE in_binary_integer(p_param IN BINARY_INTEGER);
-- 231 TIMESTAMP WITH LOCAL TIME ZONE -- datetime.datetime
--PROCEDURE in_binary_integer(p_param IN BINARY_INTEGER);
-- 250 PL/SQL RECORD -- tuple - namedtuple
PROCEDURE in_record(p_param IN test_return.tr_record);
PROCEDURE in_record_of_records(p_param IN test_return.tr_record_of_records);
PROCEDURE in_record_of_nested(p_param IN test_return.tr_record_of_nested);
PROCEDURE in_record_of_plsql_table(p_param IN test_return.tr_record_of_plsql_table);
-- 251 PL/SQL TABLE -- mapping
PROCEDURE in_plsql_table(p_param IN test_return.tt_plsql_table);
PROCEDURE in_plsql_table_of_records(p_param IN test_return.tt_plsql_table_of_records);
PROCEDURE in_plsql_table_of_nested(p_param IN test_return.tt_plsql_table_of_nested);
PROCEDURE in_plsql_table_of_plsql_table(p_param IN test_return.tt_plsql_table_of_plsql_table);
-- 252 PL/SQL BOOLEAN -- bool
PROCEDURE in_bool(p_param IN BOOLEAN);
END test_in_params;