-440 NO AUTHORIZED routine-type BY THE NAME routine-name HAVING COMPATIBLE ARGUMENTS WAS FOUND
Explanation
An attempt was made to invoke a routine, but DB2® could not resolve the invocation of a routine, including the argument list, to a specific routine definition.
- routine-type
- The type of routine, such as FUNCTION or PROCEDURE.
- routine-name or schema-name.routine-name
- The name of the routine. If the originating statement references a qualified name, the routine name in the message text is qualified by the name of the schema.
Possible causes for this error include:
- The routine name was either incorrectly specified or does not exist in the database.
- A qualified reference was used, and the schema qualifier was incorrectly specified.
- The user's SQL path does not contain the schema to which the function belongs, and an unqualified reference was used.
- The wrong number of arguments was included.
- The right number of arguments was included in the routine reference, but the data type of one or more of the arguments is incorrect.
- The invoker of the routine is not authorized to execute the routine.
System action
The statement cannot be processed.
Programmer response
Use the routine name identified in the message to find the invocation, and verify that the invocation can be resolved to the intended routine, based on the function and procedure resolution processes.
- For functions: Function resolution
- For procedures: CALL
To ensure that the intended routine is invoked, specify a qualified routine name whenever possible.
SQLSTATE
42884
