===== ISO/IEC 9075-04:2016 Database languages — SQL — Part 4: Persistent stored modules (SQL/PSM) =====
[[dido:public:ra:xapend:xapend.b_stds:tech:iso:start| return to the ISO Standards ]]

<table>
<caption>Data sheet for Database languages — SQL — Part 4: Persistent stored modules (SQL/PSM)</caption>
| Title                      | Database languages — SQL — Part 4: Persistent stored modules |
| Acronym                    | SQL/PSM |
| Version                    | 2016|
| Document Number            | 9075-4:2016|
| Release Date               | 2016-12  |
| Reference                  | [[https://www.iso.org/obp/ui/#iso:std:iso-iec:9075:-4:ed-6:v1:en]] |
</table>

  : **Note**: The following is an excerpt from the official ISO catalog. It is provided here as a convenience and is not authoritative. Refer to the original document as the authoritative reference.

==== Scope ====

//This part of International Standard ISO/IEC 9075 specifies the [[dido:public:ra:xapend:xapend.a_glossary:s:syntax|syntax]] and [[dido:public:ra:xapend:xapend.a_glossary:s:semantics|semantics]] of a database language for declaring and maintaining persistent database language routines in [[dido:public:ra:xapend:xapend.a_glossary:s:sql|SQL]]-server modules.//

//The database language for <externally-invoked procedure>s and <SQL-invoked routine>s includes://

  * //The specification of statements to direct the flow of control.//
  * //The assignment of the result of expressions to variables and parameters.//
  * //The specification of condition handlers that allow SQL-invoked routines to deal with various conditions that arise during their execution.//
  * //The specification of statements to signal and resignal conditions.//
  * //The declaration of standing SQL-server cursors.//
  * //The declaration of local variables.//

//It also includes the definition of the Information Schema tables that contain schema information pertaining to SQL-server modules and SQL-invoked routines.//

==== See Also ====

  * [[dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part1]]
  * [[dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part2]]
  * [[dido:public:ra:xapend:xapend.b_stds:tech:iso:dblangsql_part3]]
  * [[dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part9]]
  * [[dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part10]]
  * [[dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part11]]
  * [[dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part13]]
  * [[dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part14]]


/**=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
/* To add a discussion page to this page, comment out the line that says 
  ~~DISCUSSION:off~~
*/
~~DISCUSSION:on|Outstanding Issues~~
~~DISCUSSION:off~~