ISO/IEC 9075-4:2016 speciﬁes 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 speciﬁcation of statements to direct the ﬂow of control.
- The assignment of the result of expressions to variables and parameters.
- The speciﬁcation of condition handlers that allow SQL-invoked routines to deal with various conditions that arise during their execution.
- The speciﬁcation of statements to signal and resignal conditions.
- The declaration of standing SQL-server cursors.
- The declaration of local variables.
It also includes the deﬁnition of the Information Schema tables that contain schema information pertaining to SQL-server modules and SQL-invoked routines.
Status: PublishedPublication date: 2016-12
Edition: 6Number of pages: 188
Technical Committee: ISO/IEC JTC 1/SC 32 Data management and interchange
- ICS :
- 35.060 Languages used in information technology
This standard contributes to the following Sustainable Development Goal:
Buy this standard
|std 1 208|
ISO/IEC 9075-4:2011/Cor 1:2013Withdrawn
ISO/IEC 9075-4:2011/Cor 2:2015
A standard is reviewed every 5 years
Stage: 90.92 (To be revised)
Corrigenda / AmendmentsPublished
ISO/IEC 9075-4:2016/Cor 1:2019Published
ISO/IEC 9075-4:2016/Cor 2:2022
Will be replaced byUnder development
ISO/IEC DIS 9075-4
Got a question?
Check out our FAQs
Monday to Friday - 09:00-12:00, 14:00-17:00 (UTC+1)
Keep up to date with ISO
Sign up to our newsletter for the latest news, views and product information.