Previous Topic: -291 - INDEX <xxxxx> NOT IN SEQUENCENext Topic: -293 - PREDICATE INVALID BECAUSE HOST VARIABLE <nnn> HAS THE NULL VALUE


-292 - <nnnn> VARIABLES PROVIDED FOR <nnnn> SELECT LIST COLUMNS

Explanation

For SELECT INTO, the number of host variables in the INTO list must match the number of columns in the SELECT list. For FETCH, the number of host variables cannot be greater than the number of SELECT list columns.

The SQLSTATE that equates to this SQL return code is 53S39.

User Response

Correct the number of columns in SELECT or INTO lists.