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

Adeoluwa Odein stratfordtenants at
Wed Jul 13 23:06:03 CEST 2011

On Jul 13, 5:02 pm, John Gordon <gor... at> wrote:
> In <86b9e6f2-e18e-41b9-92a2-86ea8d7b4... at> Adeoluwa Odein <stratfordtena... at> writes:
> > The same error. The sample were found on the following site --I copied
> > exactly what is written there:
> > 1.
if you define the function in the execute() method, it works (as seen
on the page).  But this is a stored procedure already residing on the
DB.  A function/procedure outside of a package, actually works, but
then you lose access to private data; which is while I used a package.

> Ah, I see.  You're supposed to call c.fetchall() afterwards to retrieve
> the OUT parameter.
> Also, the example page defines the called object as a function, not a
> procedure.  Maybe that's the problem?  Try defining RS22 as a function
> and see if that helps.
> You might also try defining it outside of a package, as that is how the
> example code does it.
> --
> John Gordon                   A is for Amy, who fell down the stairs
> gor... at              B is for Basil, assaulted by bears
>                                 -- Edward Gorey, "The Gashlycrumb Tinies"

More information about the Python-list mailing list