In this blog post, let’s learn about the error message “4454 The SQL statement has a User Defined Function function that is invoked with an unsupported argument.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4454 The SQL statement has a User Defined Function function that is invoked with an unsupported argument.
Reason for the Error
You attempted to use a User Defined Function with an argument type that is not yet supported, such as another User Defined Function.
Solution
Rewrite the query to use only supported arguments and retry the query