Stay organized with collectionsSave and categorize content based on your preferences.
The GoogleSQL procedural language lets you execute multiple statements
in one query as a multi-statement query. You can use
a multi-statement query to:
Run multiple statements in a sequence, with shared state.
Automate management tasks such as creating or dropping tables.
CALL
Syntax
CALLprocedure_name(procedure_argument[,…])
Description
Calls aprocedurewith an argument list.procedure_argumentmay be a variable or an expression.
The maximum depth of procedure calls is 50 frames.
Examples
The following example cancels a query with the query ID12345.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-09-04 UTC."],[],[],null,["# Procedural language in GoogleSQL\n\nThe GoogleSQL procedural language lets you execute multiple statements\nin one query as a multi-statement query. You can use\na multi-statement query to:\n\n- Run multiple statements in a sequence, with shared state.\n- Automate management tasks such as creating or dropping tables.\n\n`CALL`\n------\n\n**Syntax** \n\n```sql\nCALL procedure_name (procedure_argument[, ...])\n```\n\n**Description**\n\nCalls a [procedure](/spanner/docs/reference/standard-sql/stored-procedures) with an argument list.\n`procedure_argument` may be a variable or an expression.\n\nThe maximum depth of procedure calls is 50 frames.\n\n**Examples**\n\nThe following example cancels a query with the query ID `12345`. \n\n```sql\nCALL cancel_query(\"12345\");\n```"]]
