Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


CALL


Calls a procedure.

Usage

Embedded/Interactive/ODBC/Procedural/JDBC.

Description

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.

Restrictions

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.

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.

Standard compliance

Standard
Compliance
Comments
X/Open-95
SQL92
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
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX