In this blog post, let’s learn about the error message “11226 All SQL parameters associated with a Java main method must have a parameter mode of IN.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11226 All SQL parameters associated with a Java main method must have a parameter mode of IN.
Reason for the Error
In a CREATE PROCEDURE statement, the Java method specified in the EXTERNAL NAME clause was a Java main() method, and an OUT or INOUT parameter was declared in the SQL parameter list. All SQL parameters associated with Java main() methods must be IN parameters.
Solution
Correct the SQL parameter list, and retry the SQL/MX statement
