Skip to content

ERR-201436 The number of host variables exceed the maximum limit (1024)#

Version#

4.3.9 or later

Explanation#

Unable to create the procedure.

Cause#

1024 is the maximum number of host variables that can be used. This error occurs if the number of host variables in the procedure exceeded this number.

Action#

The WITH clause (for Altibase 6.3.1 or later) can be used to reduce the number of host variables. It can use more than 1024 by using variable substitution as shown below.

WITH dataset1 AS (SELECT V_YYYYMM AS V_EXEC_YYYYMM FROM dual )

For versions below 6.3.1, either separate the processing modules for each task or change the logic to handle it in a different way, apart from a host variable as the WITH clause is not supported.

Reference#

N/A