Restrictions

If the name does not uniquely identify a UDR, you must enter one or more appropriate values for parameter_type.

When you use this statement, the type of UDR cannot be ambiguous. The UDR that you specify must refer to either a user-defined function or a user-defined procedure. If either of the following conditions exist, the database server returns an error:
  • The name (and parameters) that you specify applies to both a user-defined procedure and a user-defined function.
  • The specific name that you specify applies to both a user-defined function and a user-defined procedure.