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.