The routine signature
The routine signature uniquely identifies the routine.
The query parser uses the routine signature when you invoke a UDR.
The routine signature includes the following information:
- The type of routine: procedure or function
- The routine name
- The number of parameters
- The data types of the parameters
- The order of the parameters
- The owner name
Important: The signature of a routine does not include
return types. Consequently, you cannot create two user-defined functions
that have the same signature but different return types.