Issue2760

classification

Title:	How to call procedure with use zxjdbc and get back OUT parameter?
Type:	crash	Severity:	normal
Components:	zxjdbc	Versions:	Jython 2.5
		Milestone:

process

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.

Messages
msg12442 (view)	Author: Artem (youlfey)	Date: 2019-04-18.12:52:58
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?

msg12442 (view)

Author: Artem (youlfey)

Date: 2019-04-18.12:52:58

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 15:23:41	youlfey	set	type: crash
2019-04-18 12:52:59	youlfey	create