Skip to content

Commit e831d1f

Browse files
committed
simple out parameters are now supported
1 parent 936aacb commit e831d1f

4 files changed

Lines changed: 35 additions & 0 deletions

File tree

‎plsql/client.py‎

Lines changed: 18 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -87,7 +87,25 @@ def __call__(self, **kwargs):
8787
if self.definition.object_type == FUNCTION:
8888
return cursor.callfunc(self.name, self.return_type, keywordParameters=kwargs)
8989
elif self.definition.object_type == PROCEDURE:
90+
91+
out_parameters = [
92+
(argument.argument_name.lower(), cursor.var(self.argument_mapping[argument.data_type]))
93+
for argument
94+
in self.arguments
95+
if 'OUT' in argument.in_out
96+
]
97+
98+
for name, parameter in out_parameters:
99+
kwargs[name] = parameter
100+
90101
cursor.callproc(self.name, keywordParameters=kwargs)
102+
103+
return {
104+
name: parameter.getvalue()
105+
for name, parameter
106+
in out_parameters
107+
}
108+
91109
else:
92110
raise NotImplementedError(f'Unrecognized object_type "{self.definition.object_type}"!')
93111

‎tests/conftest.py‎

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -45,3 +45,9 @@ def string_function(plsql):
4545
def simple_procedure(plsql):
4646
with managed_object(plsql, 'procedure', 'simple_procedure'):
4747
yield
48+
49+
50+
@pytest.fixture(scope='module')
51+
def procedure_out_params(plsql):
52+
with managed_object(plsql, 'procedure', 'procedure_out_params'):
53+
yield
Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,6 @@
1+
CREATE OR REPLACE PROCEDURE procedure_out_params(p_str OUT VARCHAR2) IS
2+
v_int INTEGER;
3+
BEGIN
4+
v_int := 21 * 2;
5+
p_str := TO_CHAR(v_int);
6+
END;

‎tests/test_procedures.py‎

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,2 +1,7 @@
11
def test_simple_procedure(plsql, simple_procedure):
22
plsql.simple_procedure()
3+
4+
5+
def test_procedure_out_params(plsql, procedure_out_params):
6+
result = plsql.procedure_out_params()
7+
assert result == {'p_str': '42'}

0 commit comments

Comments
 (0)