Calling stored procedures from zxJDBC

[Anthony Enache Brown]

Hi there,

I'm writing a script against a Sysbase Adaptive Server Enterprise
11.9.2.1, and I'm having a tough time getting it to call a stored
procedure.

The jython code looks like this:

db = zxJDBC.connect(d, u, p, v)
c = db.cursor(1)
c.execute( "execute DELETE_QUEUED_ACCOUNTS" )

This fails with:

Traceback (innermost last):
  File "<console>", line 1, in ?
Error: SELECT INTO command not allowed within multi-statement
transaction.
 Severity 16, State 1, Procedure 'FUTDEV DELETE_QUEUED_ACCOUNTS', Line
54 [SQLCode: 226], [SQLState: 01000]

The same statement from within iSql works without a hitch.

Any ideas as to what I am doing wrong?

Thanks for your help,

Anthony