Message12442

Author youlfey
Recipients youlfey
Date 2019-04-18.12:52:58
SpamBayes Score -1.0
Marked as misclassified Yes
Message-id <1555591979.19.0.232659389097.issue2760@roundup.psfhosted.org>
In-reply-to
Content
If I use official example from http://www.jython.org/archive/21/docs/zxjdbc.html

>>> 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
['tested']

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 (https://stackoverflow.com/questions/53946480/wrong-number-or-types-of-arguments-in-call-to-procedure-with-use-zxjdbc) have answer, but run the example with OUT parameter failed. Can you show an example that works with OUT parameter?
History
Date User Action Args
2019-04-18 12:52:59youlfeysetrecipients: + youlfey
2019-04-18 12:52:59youlfeysetmessageid: <1555591979.19.0.232659389097.issue2760@roundup.psfhosted.org>
2019-04-18 12:52:59youlfeylinkissue2760 messages
2019-04-18 12:52:58youlfeycreate