This statement executes a database procedure.

This statement has the following syntax:

The execute procedure statement executes a database procedure. This procedure must be registered before the execute procedure statement calls it, although registration does not need to be done within the application that issues the execute procedure statement.

The execute procedure statement lets you pass simple variable values to the procedure using the optional parameter list. The data type of the value that you assign to a parameter must be compatible with the data type of the parameter.

The procedure can return a single value to the procedure or frame that executed the execute procedure statement. The variable that receives the return value must be an integer data type.

Using the optional into cursorobjreference clause allows database procedures to return data sets. This optional clause is currently not available running against the Ingres DBMS.

If you are using the execute procedure statement with non-Ingres servers, see the section "Database Procedure Management" in the Enterprise Access Developing Portable Applications Guide for information about declaring and executing DBMS procedures (see http://docs.actian.com/).