| |
- Causa
- REFERENCE TO FUNCTION function-name WAS NAMED WITHOUT A SIGNATURE, BUT THE FUNCTION IS NOT UNIQUE WITHIN ITS SCHEMA.
References to a function without a signature are permitted, but the named function function-name must be unique in its schema and it is not.
Note also that in the ALTER FUNCTION, DROP FUNCTION, COMMENT ON FUNCTION, GRANT and REVOKE statements for EXECUTE on functions, an unqualified
reference is qualified with the statement authorization ID, and this is the schema where the problem can be found.
In the SOURCE clause of a CREATE FUNCTION statement, the qualification comes from the CURRENT PATH.
In this case, the first schema in the path containing a function with this name had other functions by the same name.
- Ação do sistema
- The statement cannot be executed.
- Resposta ao Desenvolvedor
- Correct the reference by one of the following:
- completing the signature
- using the SPECIFIC name of the desired function
- changing the CURRENT PATH
SQLSTATE: 42725
© Copyright IBM Corp.
|
| |
