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 that do not have default values are missing.
  • The fully-qualified procedure name or the routine signature is not unique.
  • No procedure with the specified name or signature is found.
  • In a distributed transaction, a UDR that is running on a subordinate participating server calls a remote procedure on another server instance
For example, the following statement fails with an error:
EXECUTE PROCEDURE ifx_unload_module
   ("C:\usr\apps\opaque_types\circle.dll");  
This built-in procedure requires a second argument, as explained in the topic IFX_UNLOAD_MODULE Function.

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. (The specific name of an external UDR is valid in DDL statements, but is not valid in contexts where you invoke the procedure.)