EXECUTE PROCEDURE Syntax
Examples
To execute thesqlp SQL procedure:
EXECUTE PROCEDURE Example
SQL Procedures
EXECUTE PROCEDURE
SQL procedures can be executed on-demand.
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.