Symptom
- Using ODBC with the SQLBindVariable and SQLDirectExecute calls to call a SELECT from a stored procedure with bound parameters (?) that does not define a result clause (e.g. RESULT()) in SQL Anywhere 16
- Upon first execution and despite providing sufficient SQLBindVariable calls for the proper positions, the error: SQLCODE -188 "Not enough values host variables" is reported ( [Sybase][ODBC Driver][SQL Anywhere]Not enough values for host variables )
- Re-execution of the statement using SQLDirectExecute works successfully
Read more...
Environment
- SAP SQL Anywhere 16
- A client using the ODBC API (or any API that uses ODBC - i.e. ADO.NET OdbcConnection)
Product
SAP SQL Anywhere 16.0
Keywords
Sybase, SQLA, vars, , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , 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.
SAP Knowledge Base Article - Preview