CALL

Remarks

Use the CALL statement to invoke a stored procedure. The stored procedure may be a user-defined one or a system stored procedure.

Examples

The following example calls a user-defined procedure without parameters:

CALL NoParms() or CALL NoParms 

The following examples call a user-defined procedure with parameters:

CALL Parms(vParm1, vParm2) 
CALL CheckMax(N.Class_ID) 

The following statement lists the column information for all columns in the Department table.

CALL psp_columns(`Demodata',`Department') 

See Also

CREATE PROCEDURE

CREATE TRIGGER

EXECUTE

System Stored Procedures