The Reference Guide should explain the method resolution rules for functions and procedures. The full rules are described in the SignatureMapping.html webpage attached to
DERBY-3652. At this point, Derby implements those rules for the datatypes which Derby supports, except for LOB arguments. That exception may be largely lifted as a result of the work being done on DERBY-4066.