Sybase procedure not work

[gilbert F.]

Hi Sybase community,

I am using Java to call a procedure for Sybase. The procedure is
called but no data in the database gets updated. The 9th parameter is
registered as an "output" parameter. This output parameter tells how
many rows get updated in the Sybase.

The procedure has been confirmed to be correct. Therefore I think I
miss anything in my Java code? Any help?

Thanks so much.

----------------------------------------------------

String execPRC = "{call
mg_update_keyword_bid(?, ?, ?, ?, ?, ?, ?, ?, ?)}";
cs =
(SybCallableStatement)conn.prepareCall(execPRC);

cs.setString(1, token);

cs.setLong(2, advertiserId);
cs.setString(3, campaignType);

cs.setLong(4, campaignId);
cs.setLong(5, listingId);
cs.setLong(6, keywordId);
cs.setString(7, keyword);

cs.setDouble(8, bid);

cs.registerOutParameter(9, Types.VARCHAR);
cs.execute();

updateString = cs.getString(9);
logger.info("updateString: --> " + updateString);
cs.close();