On Jul 13, 5:02 pm, John Gordon <gor...@panix.com> wrote: > In <86b9e6f2-e18e-41b9-92a2-86ea8d7b4...@f35g2000vbr.googlegroups.com> > Adeoluwa Odein <stratfordtena...@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...@panix.com B is for Basil, assaulted by bears > -- Edward Gorey, "The Gashlycrumb Tinies" -- http://mail.python.org/mailman/listinfo/python-list