Title: How to call procedure with use zxjdbc and get back OUT parameter?
Type: crash Severity: normal
Components: zxjdbc Versions: Jython 2.5
Status: open Resolution:
Dependencies: Superseder:
Assigned To: Nosy List: youlfey
Priority: Keywords:

Created on 2019-04-18.12:52:59 by youlfey, last changed 2019-04-18.15:23:41 by youlfey.

msg12442 (view) Author: Artem (youlfey) Date: 2019-04-18.12:52:58
If I use official example from

>>> c = db.cursor() # open the database as in the examples above
>>> c.execute("create or replace function funcout (y out varchar2) return varchar2 is begin y := 'tested'; return 'returned'; end;")
>>> params = [None]
>>> c.callproc("funcout", params)
>>> print params

I get error:

PLS-00306: wrong number or types of arguments in call to 'FUNCOUT'
ORA-06550: line 1, column 7: PL/SQL: Statement ignored

The question ( have answer, but run the example with OUT parameter failed. Can you show an example that works with OUT parameter?
Date User Action Args
2019-04-18 15:23:41youlfeysettype: crash
2019-04-18 12:52:59youlfeycreate