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

[Adeoluwa Odein]

On Jul 13, 5:02 pm, John Gordon <gor... at panix.com> wrote:
> In <86b9e6f2-e18e-41b9-92a2-86ea8d7b4... at f35g2000vbr.googlegroups.com> Adeoluwa Odein <stratfordtena... at gmail.com> writes:
>
> > The same error. The sample were found on the following site --I copied
> > exactly what is written there:
> > 1.http://www.jython.org/archive/21/docs/zxjdbc.html
>
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 panix.com              B is for Basil, assaulted by bears
>                                 -- Edward Gorey, "The Gashlycrumb Tinies"