Calls a procedure.
The CALL statement is used to invoke a procedure. The values specified for expression must correspond to the parameters defined for the procedure.
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 embedded SQL 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.
MIMER EXTENSION Support for the CALL statement is a Mimer SQL extension. SQL/PSM EXTENDED Support for procedures that return a result-set (i.e. Result Set Procedures) is a Mimer SQL extension.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40