Skip to content

Commit dd26f66

Browse files
committed
Revert "changed to using SID added nested tables"
This reverts commit 462e984
1 parent 41f6656 commit dd26f66

2 files changed

Lines changed: 0 additions & 26 deletions

File tree

‎plsql/client.py‎

Lines changed: 0 additions & 16 deletions
Original file line numberDiff line numberDiff line change
@@ -41,21 +41,6 @@ def oracle_plsql_table(connection, argument, mapping_of_recs):
4141
return mapping_of_recs
4242

4343

44-
def oracle_table(connection, argument, list_of_recs):
45-
table_type = connection.gettype(argument.extended_type)
46-
table = table_type.newobject()
47-
48-
if table_type.elementType is not None:
49-
for value in list_of_recs:
50-
rec = oracle_plsql_record(connection, None, value, table_type.elementType)
51-
table.append(rec)
52-
return table
53-
else:
54-
for value in list_of_recs:
55-
table.append(value)
56-
return table
57-
58-
5944
def translate_types(connection, arguments, parameters, conversion_func, data_type):
6045
return {
6146
argument.argument_name.lower(): conversion_func(
@@ -79,7 +64,6 @@ class Subprogram:
7964
AND object_name = :object_name
8065
AND object_id = :object_id
8166
AND subprogram_id = :subprogram_id
82-
AND data_level = 0
8367
"""
8468

8569
# fixme: not gonna scale with other types

‎tests/sql/package/test_package-b.sql‎

Lines changed: 0 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -6,16 +6,6 @@ CREATE OR REPLACE PACKAGE BODY test_package AS
66
RETURN tt_integers(1, 2, p_integer);
77
END;
88

9-
FUNCTION in_integers(pt_integers IN tt_integers)
10-
RETURN INTEGER IS
11-
v_sum INTEGER;
12-
BEGIN
13-
SELECT SUM(column_value)
14-
INTO v_sum
15-
FROM TABLE(pt_integers);
16-
RETURN v_sum;
17-
END;
18-
199
FUNCTION return_record
2010
RETURN tr_rec IS
2111
vr_rec tr_rec;

0 commit comments

Comments
 (0)