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