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

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


In <01efb6ac-deaa-4bdb-8b2d-b603bdddec57 at n5g2000yqh.googlegroups.com> Adeoluwa Odein <stratfordtenants at gmail.com> 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 panix.com              B is for Basil, assaulted by bears
                                -- Edward Gorey, "The Gashlycrumb Tinies"




More information about the Python-list mailing list