In this blog post, let’s learn about the error message “11216 Java execution: Data overflow occurred while retrieving data at parameter position parameter number.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11216 Java execution: Data overflow occurred while retrieving data at parameter position parameter number.
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
