Symptom
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(ErrorMessage.java:832) at com.sybase.jdbc4.jdbc.ParamManager.nextResult(ParamManager.java:1128) at com.sybase.jdbc4.jdbc.ParamManager.doGetOutValueAt(ParamManager.java:877) at com.sybase.jdbc4.jdbc.ParamManager.getOutValueAt(ParamManager.java:848) at com.sybase.jdbc4.jdbc.SybCallableStatement.getInt(SybCallableStatement.java:947) at Test.main(Test.java:17)
- java.sql.SQLException: JZ0SB: Parameter index out of range: 3. at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(ErrorMessage.java:800) at com.sybase.jdbc4.jdbc.ParamManager.checkIndex(ParamManager.java:376) at com.sybase.jdbc4.jdbc.ParamManager.doRegisterParam(ParamManager.java:796) at com.sybase.jdbc4.jdbc.ParamManager.registerParam(ParamManager.java:787) at com.sybase.jdbc4.jdbc.SybCallableStatement.registerOutParameter(SybCallableStatement.java:430) at Test.main(Test.java:15)
Read more...
Environment
- SAP Sybase Software Developer Kit (SDK) 15.7
- SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
Product
SAP Adaptive Server Enterprise SDK 16.0 ; Sybase Software Developer Kit 15.7
Keywords
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.