CALL

---

Calls a procedure.

Usage

Embedded/Interactive/ODBC/Procedural/JDBC.

Description

The CALL statement is used to invoke a procedure. As there can be multiple procedures with the same name, the number of parameters and their type is used to determine which actual procedure should be invoked.

The nature of each expression depends on the parameter it applies to. For parameters with mode OUT or INOUT, expression must be a target-variable, see Target Variables. For parameters with mode IN, expression may be a value-expression.

The value of expression must be assignment-compatible with the data type of the parameter to which it is applied, see Assignments.

Restrictions

In ESQL, the CALL statement is not used to invoke result set procedures, see DECLARE CURSOR for information about calling result set procedures.

In interactive SQL, the CALL statement is used to invoke all types of procedures.

Recursion is permitted, an error will be raised if the internal recursion limit is exceeded.

In a procedural usage context, the called procedure must have an access-clause which is lower or equal to that of the calling procedure, see CREATE PROCEDURE for details about procedure access clause values.

Notes

The CALL statement is not used to invoke a function. A function is invoked by specifying its name and parameter list in a context where a value expression would normally be used.

Examples

 CALL PROC1();
 
 CALL PROC2(X,Y);
 
 CALL IDENT1.PROC7(CURRENT_DATE, X+3, Z);

Standard Compliance

Standard	Compliance	Comments
SQL-2003	Core	Fully compliant.

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se