2.1.2.234 T471, Result sets return value

V0270:

The specification states the following:

 Subclause 11.60, "<SQL-invoked routine>":
  
 <returned result sets characteristic> ::=
 DYNAMIC RESULT SETS <maximum returned result sets>
  
 ...
  
 Conformance Rules
  
 Without Feature T471, "Result sets return value", conforming SQL language shall not contain a <returned result sets characteristic>.
  
 Subclause 14.2, "<cursor properties>":
  
 <cursor properties> ::=
 [ <cursor sensitivity> ] [ <cursor scrollability> ] CURSOR
 [ <cursor holdability> ]
 [ <cursor returnability> ]
  
 ...
  
 <cursor returnability> ::=
 WITH RETURN
 | WITHOUT RETURN
  
 ...
  
 Conformance Rules
  
 Without Feature T471, "Result sets return value", conforming SQL language shall not contain a <cursor returnability>.
  
 Subclause 20.16, "<allocate cursor statement>":
  
 <allocate received cursor statement> ::=
 ALLOCATE <cursor name>
 [ CURSOR ] FOR PROCEDURE <specific routine designator>
  
 Conformance Rules
  
 Without Feature T471, "Result sets return value", conforming SQL language shall not contain an <allocate received cursor statement>.

The [ISO/IEC9075-2:2008] specification differs as follows:

 Subclause 20.15, "<allocate cursor statement>":
  
 <cursor intent> ::=
 <statement cursor>
 | <result set cursor>
  
 ...
  
 <result set cursor> ::=
 [ CURSOR ] FOR PROCEDURE <specific routine designator>
  
 ...
  
 Conformance Rules
  
 Without Feature T471, "Result sets return value", conforming SQL language shall not contain a <result set cursor>.

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL does not support this feature.