Calls a procedure.
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.
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.
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.
ExamplesCALL PROC1(); CALL PROC2(X,Y); CALL IDENT1.PROC7(CURRENT_DATE, X+3, Z);
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40