python error PLS-00306: wrong number or types of arguments in

John Gordon gordon at
Wed Jul 13 13:40:35 EDT 2011

In <01efb6ac-deaa-4bdb-8b2d-b603bdddec57 at> Adeoluwa Odein <stratfordtenants at> writes:

> Hello
> I am using the zxJDBC package with jython (similar to python), and I
> am having "python error PLS-00306: wrong number or types of arguments"
> error when using the "callproc()" method to execute a stored
> procedure.

> The Oracle stored procedure takes a single OUT varchar2 parameter.  My
> code is as follows:

> p = [None]
> c.callproc('pkg1_returns', p);

If the procedure takes a varchar2 parameter, why are you passing [None]?

It might help if you posted the method signature of the Oracle stored
procedure you're trying to call.

John Gordon                   A is for Amy, who fell down the stairs
gordon at              B is for Basil, assaulted by bears
                                -- Edward Gorey, "The Gashlycrumb Tinies"

More information about the Python-list mailing list