CALL

Invokes a stored procedure created with CREATE PROCEDURE (Stored).

Syntax

CALL [[database.]schema.]procedure( [ argument-list] );

Parameters

[database.]schema

Database and schema. The default schema is public. If you specify a database, it must be the current database.

procedure

The name of the stored procedure, where procedure conforms to conventions described in Identifiers.

argument-list

A comma-delimited list of arguments to pass to the stored procedure, whose types correspond to the types of the argument's IN parameters.

Privileges

Non-superuser: EXECUTE on the procedure

Examples

See Executing Stored Procedures and Stored Procedures: Use Cases and Examples.