https://community.sap.com/t5/technology-q-a/not-enough-values-for-host-variables-error-message/qaa-p/13844028#M4874871 <P>I found the problem.<BR /> Since my Dynamic Query has Quoted Identifiers, I have to use "Execute Immediate With Quotes On".<BR /> Still odd, that it somehow works in dbisql ! </P> <P>greg</P> Fri, 10 Nov 2017 07:06:53 GMT Former Member 2017-11-10T07:06:53Z https://community.sap.com/t5/technology-q-a/not-enough-values-for-host-variables-error-message/qaq-p/13844027 <P>This problem has been posted before:<BR /> When calling a stored procedure from an application, the error message "Not enough values for host variables is displayed". The stored procedure works fine within dbisql </P> <P>The problem variable is: Declare MyVar numeric(18,9) Array(56);</P> <P>I set the variable ( 1 to 55 ) using a Dynamic Query in a Loop, and Execute Immediate. <BR /> It works when called in dbisql, but not when called thru a JDBC Connection.<BR /> The Application does appear to work, if I hard code the Array Values ( and not use Execute Immediate ).<BR /> Using SQL Anywhere 16.0.0.2043. </P> <P>greg</P> Fri, 10 Nov 2017 01:52:59 GMT https://community.sap.com/t5/technology-q-a/not-enough-values-for-host-variables-error-message/qaq-p/13844027 Former Member 2017-11-10T01:52:59Z https://community.sap.com/t5/technology-q-a/not-enough-values-for-host-variables-error-message/qaa-p/13844028#M4874871 <P>I found the problem.<BR /> Since my Dynamic Query has Quoted Identifiers, I have to use "Execute Immediate With Quotes On".<BR /> Still odd, that it somehow works in dbisql ! </P> <P>greg</P> Fri, 10 Nov 2017 07:06:53 GMT https://community.sap.com/t5/technology-q-a/not-enough-values-for-host-variables-error-message/qaa-p/13844028#M4874871 Former Member 2017-11-10T07:06:53Z