com.sybase.jdbc2.jdbc.SybSQLException: Execute cursor
'jconnect_implicit_1' is declared on a procedure which
contains a non-SELECT or a SELECT with a COMPUTE clause. For
the declaration of this cursor to be legal it should have a
single SELECT statement w
com.sybase.jdbc2.jdbc.SybSQLException: Stored procedure 'sp_validate_data' may be
run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause
the current session to use unchained transaction mode.
Hi. It means what it says. Is sp_validate_data your procedure? Sybase stored procedures, by default,
are only allowed to run in the chained/unchained (autoCommit(false)/autoCommot(true)) mode in which
they were created. To get around this, look up the sybase tool sp_procxmode, and call it with your
procedure name(s) to allow Sybase to run them whether you're in a transaction or not.