Using cursor.callproc with zxJDBC

[Paul Boddie]

Gerhard Haering <gerhard.haering at gmx.de> wrote in message news:<slrnal4b09.190.gerhard.haering at lilith.my-fqdn.de>...
> I have problems calling an Oracle stored procedure using zxJDBC (the one
> shipped with Jython 2.1).

[...]

> Doing it manually like this seems to work, but looks of course ugly :-/
> 
>     cursor.execute("""
>         BEGIN
>             %s.SCHEDULING_PKG.P_FILL_SCHEDULING(%i);
>         END;
>         """ % (PKGNAME, self.id))
> 
> Could anybody please tell me how to invoke (Oracle) stored procedures from
> Jython?

What about the JDBC syntax for calling procedures? Something like this:

  {? = call PACKAGE.SCHEDULING_PKG.P_FILL_SCHEDULING(?)}

I suppose it depends on what zxJDBC does behind the scenes with its input.

Paul