- When a dynamic SQL with homogeneous batch parameters is executed and it's required a recompile and
- The configuration parameter "streamlined dynamic SQL" is set to OFF, then
- Error 16817 may occur:
A query plan cannot be generated for DML command executed with homogeneous batch parameters. The batch was aborted.
- Here is a sample Java stack trace when Error 16817 occurs:
com.sybase.jdbc4.jdbc.SybBatchUpdateException: JZ0BE: BatchUpdateException: Error occurred while executing batch statement: A query plan cannot be generated for DML command executed with homogeneous batch parameters. The batch was aborted.
SAP Adaptive Server Enterprise (ASE) 15.7
774383, CR774383 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.