Stored procedures


A stored procedure is an executable object stored on the data source. Generally, it is one or more SQL statements that have been created using specific features of used DBMS. SQL only standardizes way how to call them.


Syntax of stored procedure calling

{[result=]CALL procedure_name[({parameter})]}

The first and last curly bracket don't have the meaning determined in the chapter Typography, but they are part of the syntax.



result The result of procedure if it acts as a function.
procedure_name Procedure's name
parameter Parameter of procedure. Some DBMS supports parameter omitting by using default value and discarding return value, if a parameter is the output one. Parameter can serve as  input, output or input/output.