HPE NonStop SQL/MX Error – 11227 All SQL parameters associated with a Java main method must be a SQL character type.

Data 17 Views 1 Min Read

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

Tags: