8.4. CALL

Synopsis

  1. CALL procedure_name ( [ name => ] expression [, ...] )

Description

Call a procedure.

Procedures can be provided by connectors to perform data manipulation oradministrative tasks. For example, the System Connector defines aprocedure for killing a running query.

Some connectors, such as the PostgreSQL Connector, are for systemsthat have their own stored procedures. These stored procedures are separatefrom the connector-defined procedures discussed here and thus are notdirectly callable via CALL.

See connector documentation for details on available procedures.

Examples

Call a procedure using positional arguments:

  1. CALL test(123, 'apple');

Call a procedure using named arguments:

  1. CALL test(name => 'apple', id => 123);

Call a procedure using a fully qualified name:

  1. CALL catalog.schema.test();