Causes of Errors

EXECUTE PROCEDURE returns an error under the following conditions:

• It has more arguments than the called procedure expects.
• One or more arguments are missing and do not have default values. Unlike Dynamic Server, Extended Parallel Server can invoke procedures with missing arguments, but the procedure might fail if a missing argument causes another error (for example, an undefined value for a variable).
• The fully qualified procedure name or the routine signature is not unique.
• No procedure with the specified name or signature is found.

If the procedure name is not unique within the database, you must specify enough parameter_type information to disambiguate the name. See Arguments for additional information about how to specify parameters when invoking a procedure. (In Dynamic Server, the specific name of an external UDR is valid in DDL statements, but is not valid in contexts where you invoke the procedure.)