The actual jython/python call is: p = [None] c.callproc('c2_pkg.RS22', p);
I used a placeholder initially; now that you have the SQL code, there it is. It essentially invokes the stored procedure, and it should return the OUT variable p, with some value. It doesn't have to be a cursor fetch; even a minor text assignment. On Jul 13, 2:10 pm, John Gordon <gor...@panix.com> wrote: > In <9e937261-d05d-477a-90d2-a690e85e1...@h17g2000yqn.googlegroups.com> > Adeoluwa Odein <stratfordtena...@gmail.com> writes: > > > Thanks, your assistance will be greatly appreciated on the right way > > forward. See the Stored Procedure Below -very simple: > > I don't see a procedure named "pkg1_returns", which is the prodecure > called by your code. Where is this procedure? > > -- > 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