> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# EXECUTE PROCEDURE

<a id="sql-procedures-execute" />

*SQL procedures* can be executed on-demand.

```sql title="EXECUTE PROCEDURE Syntax" theme={null}
EXEC[UTE] [PROCEDURE] [<schema name>.]<procedure name> [()]
```

If the final statement in the *SQL procedure* is an output-generating statement
*(SQL query, SHOW command, etc.)*, the output of that statement alone will be
returned to the user; all other statements that generate output will be ignored.

If there is an error executing any statement, the *SQL procedure* will stop
immediately and report the error.  Any database modifications prior to the error
will not be rolled back.

## Examples

To execute the `sqlp` *SQL procedure*:

```sql EXECUTE PROCEDURE Example theme={null}
EXECUTE PROCEDURE example.sqlp
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.