return to the ISO Standards

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.

This part of International Standard ISO/IEC 9075 specifies the syntax and semantics of a database language for declaring and maintaining persistent database language routines in 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.

• ISO/IEC 9075-01:2016 Database languages — SQL — Part 1: Framework (SQL/Framework)
• ISO/IEC 9075-02:2016 Database languages — SQL — Part 2: Foundation (SQL/Foundation)
• ISO/IEC 9075-03:2016 Database languages — SQL — Part 3: Call-Level Interface (SQL/CLI)
• ISO/IEC 9075-09:2016 Database languages — SQL — Part 9: Management of External Data (SQL/MED)
• ISO/IEC 9075-10:2016 Database languages — SQL — Part 10: Object language bindings (SQL/OLB)
• ISO/IEC 9075-11:2016 Database languages — SQL — Part 11: Information and definition schemas (SQL/Schemata)
• ISO/IEC 9075-13:2016 Database languages — SQL — Part 13: SQL Routines and types using the Java TM programming language (SQL/JRT)
• ISO/IEC 9075-14:2016 Database languages — SQL — Part 14: XML-Related Specifications (SQL/XML)