Abstract
ISO/IEC 9075-4:2016 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.
General information
-
Status: WithdrawnPublication date: 2016-12Stage: Withdrawal of International Standard [95.99]
-
Edition: 6Number of pages: 188
-
Technical Committee :ISO/IEC JTC 1/SC 32ICS :35.060
- RSS updates
Life cycle
-
Previously
WithdrawnISO/IEC 9075-4:2011
WithdrawnISO/IEC 9075-4:2011/Cor 1:2013
WithdrawnISO/IEC 9075-4:2011/Cor 2:2015
-
Now
-
00
Preliminary
-
10
Proposal
-
20
Preparatory
-
30
Committee
-
40
Enquiry
-
50
Approval
-
60
Publication
-
90
Review
-
95
Withdrawal
Corrigenda
Correct the current edition; free; not included in the text of the existing standard.WithdrawnISO/IEC 9075-4:2016/Cor 1:2019
WithdrawnISO/IEC 9075-4:2016/Cor 2:2022
-
00
-
Revised by
PublishedISO/IEC 9075-4:2023