picoSQL - Language reference manual

Syntax:

CALL procedure-name ([argument[, argument] ...])

Purpose:

Allows to invoke a stored procedure

See also:

SELECT

Description:

This statement allows the invocation of a stored procedure previously created. The argument number can be fixed or variable, depending on the procedure declaration. Arguments are expressions, as in a SELECT statement.
Like any other SQL statement, CALL statement returns only a success or error code; it can generate a result set, like a SELECT statement, or it can generate nothing, like statements INSERT, UPDATE and DELETE. Introduced from release 2.0.