Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
EXECUTE PROCEDURE statementUse the EXECUTE PROCEDURE statement to invoke a user-defined procedure or a built-in routine. This statement is an extension to the ANSI/ISO standard for SQL.
Causes of ErrorsEXECUTE PROCEDURE returns an error under the following conditions.

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.)