com.sybase.jdbc3.jdbc.SybSQLException: Execute cursor 'jconnect_implicit_1' is declared on a procedure which has more than one SQL statement.

[sebykrueger]

Hi everyone,

I'm trying to use the JConnect lib to connect to Sybase and am getting
the following error when executing my "CallableStatement".

com.sybase.jdbc3.jdbc.SybSQLException: Execute cursor
'jconnect_implicit_1' is declared on a procedure which has more than
one SQL statment. For the declaration of this cursor to be legal the
procedure should have a single SELECT statement clause.

at com.sybase.jdbc3.tds.Tds.processEed(Tds.java:3069)
at com.sybase.jdbc3.tds.Tds.nextResult(Tds.java:2373)
at com.sybase.jdbc3.tds.Tds.getResultSetResult(Tds.java:2980)
at com.sybase.jdbc3.tds.TdsCursor.open(TdsCursor.java:295)
at
com.sybase.jdbc3.jdbc.SybCallableStatement.sendRpc(SybCallableStatement.java:
754)
at
com.sybase.jdbc3.jdbc.SybCallableStatement.execute(SybCallableStatement.java:
155)

I actually only return a single select, but have multiple selects in
the stored proc that are nested in IF ... ELSE clauses. However, only
one is returned.

I did some googling and found this user had the same problem:
http://www.advenio.com/phpBB2/viewtopic.php?p=2362&sid=3275a150fa040881638ed2cba6b9f07b

Their solution:
<Quote>
Because of the way the Sybase driver works, you need to disable the
fetch size for the connection if your procedures have more than one
select in them. You do this either on a global level in Preferences,
or on a connection level by modifying the connection settings when
connected to your database.
</Quote>

I have tried setting various parameters on the connection, but was not
able to make the exception go away. Does someone know how to fix this
problem or maybe interpret the solution fron the other forum in a JDBC-
type way for me?

Any help would be very much appreciated.

Kind regards, Sebastian.

[ankit.mah...@gmail.com]

Hi,

Did you got solution for this issue ? i am also facing same error