SAP Knowledge Base Article - Preview

2653103 - jConnect CallableStatement param fails when one param is named - SDK for SAP ASE


jConnect driver using CallableStatement causes error when parameter is literal:

  • java.sql.SQLException: JZ0SG: A CallableStatement did not return as many output parameters as the application had registered for it. at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError( at com.sybase.jdbc4.jdbc.ParamManager.nextResult( at com.sybase.jdbc4.jdbc.ParamManager.doGetOutValueAt( at com.sybase.jdbc4.jdbc.ParamManager.getOutValueAt( at com.sybase.jdbc4.jdbc.SybCallableStatement.getInt( at Test.main(
  • java.sql.SQLException: JZ0SB: Parameter index out of range: 3. at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError( at com.sybase.jdbc4.jdbc.ParamManager.checkIndex( at com.sybase.jdbc4.jdbc.ParamManager.doRegisterParam( at com.sybase.jdbc4.jdbc.ParamManager.registerParam( at com.sybase.jdbc4.jdbc.SybCallableStatement.registerOutParameter( at Test.main(



  • SAP Sybase Software Developer Kit (SDK) 15.7
  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0


SAP Adaptive Server Enterprise SDK 16.0 ; Sybase Software Developer Kit 15.7


CR#815339, CR 815339, CR# 815339, java, jre, jconn4,  jconn4.jar, parameterized, param, parm, error, fail, , KBA , BC-SYB-SDK , SDK , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.