YMatrix
Quick Start
Connecting
Benchmarks
Deployment
Data Usage
Manage Clusters
Upgrade
Global Maintenance
Expansion
Monitoring
Security
Best Practice
Technical Principles
Data Type
Storage Engine
Execution Engine
Streaming Engine(Domino)
MARS3 Index
Extension
Advanced Features
Advanced Query
Federal Query
Grafana
Backup and Restore
Disaster Recovery
Guide
Performance Tuning
Troubleshooting
Tools
Configuration Parameters
SQL Reference
Invokes a procedure.
CALL <name> ( [ <argument> ] [, ...] )CALL executes a procedure.
If the procedure has any output parameters, then a result row will be returned, containing the values of those parameters.
name The name (optionally schema-qualified) of the procedure. argument An input argument for the procedure call.
The user must have EXECUTE privilege on the procedure in order to be allowed to invoke it.
To call a function (not a procedure), use SELECT instead.
If CALL is invoked in a transaction block, then the called procedure cannot run transaction control statements. Transaction control statements are only allowed if CALL is invoked in its own transaction.
PL/pgSQL handles output parameters in CALL commands differently; refer to Calling a Procedure in the PostgreSQL documentation for more information.
CALL do_db_maintenance();CALL conforms to the SQL standard.