<p>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.</p>
<p>The database language for <externally-invoked procedure>s and <SQL-invoked routine>s includes:</p>
<p>- The specification of statements to direct the flow of control.</p>
<p>- The assignment of the result of expressions to variables and parameters.</p>
<p>- The specification of condition handlers that allow SQL-invoked routines to deal with various conditions that arise during their execution.</p>
<p>- The specification of statements to signal and resignal conditions.</p>
<p>- The declaration of standing SQL-server cursors.</p>
<p>- The declaration of local variables.</p>
<p>It also includes the definition of the Information Schema tables that contain schema information pertaining to SQL-server modules and SQL-invoked routines.</p>
Registration number (WIID)
63557
Scope
<p>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.</p>
<p>The database language for <externally-invoked procedure>s and <SQL-invoked routine>s includes:</p>
<p>- The specification of statements to direct the flow of control.</p>
<p>- The assignment of the result of expressions to variables and parameters.</p>
<p>- The specification of condition handlers that allow SQL-invoked routines to deal with various conditions that arise during their execution.</p>
<p>- The specification of statements to signal and resignal conditions.</p>
<p>- The declaration of standing SQL-server cursors.</p>
<p>- The declaration of local variables.</p>
<p>It also includes the definition of the Information Schema tables that contain schema information pertaining to SQL-server modules and SQL-invoked routines.</p>
