In this blog post, let’s learn about the error message “4452 The SQL statement has a User Defined Function function with unsupported parameter types OUT or INOUT.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4452 The SQL statement has a User Defined Function function with unsupported parameter types OUT or INOUT.
Reason for the Error
You attempted to use a User Defined Function that has INOUT or OUT parameters. These parameter modes are not supported when a UDF is used directly in a SQL query.
Solution
Rewrite the UDF to use IN parameters, recreate the UDF, and retry the query
