Icon CALL

Calls a procedure.

Syntax
CALL <FunctionName>|<ProcedureName>([<Value>[,<Value>]])

Usage
Use this statement to call a function/procedure, passing parameter values if the function/procedure being called has been defined with parameters.

Information Any return values from functions are ignored when using the CALL statement.

Examples
-- This trigger calls the external
-- SendMail procedure with which group to
-- send the email to along with the new
-- value of the Notes column for the customer
-- being updated

CREATE TRIGGER "NotesUpdate" AFTER UPDATE OF "Notes"
ON "Customer"
BEGIN
   CALL SendEmail('CustomerReps',NEWROW.Notes);
END

SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:

DeviationDetails
None
Image