SAP Knowledge Base Article - Preview

2052460 - Using ODBC with SQLBindVariable and SQLDirectExecute, the first SELECT from a procedure fails with SQLCODE -188 "Not enough values for host variables"

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.