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.


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: