In this blog post, let’s learn about the error message “11217 Java execution: Data overflow occurred while retrieving data at parameter position parameter number. Value is truncated.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11217 Java execution: Data overflow occurred while retrieving data at parameter position parameter number. Value is truncated.
Reason for the Error
During execution of a CALL statement, numeric or string overflow occurred while processing the stored procedure output value returned in parameter parameter number.
Solution
Increase the field size of the SQL data type for the specified parameter
