StoredProcedureType Definition for Parameters MaxLength is too short


The XmlSchema Definition for StoredProcedureType contains a definition for MaxLength as :
<xs:element name="MaxLength" type="xs:unsignedByte" />
The value of an unsignedByte can be an Integer between 0 and 255 which results in errors if a parameter has a larger MaxLength.
As a solution I would suggest changing the type to a 'nonNegativeInteger'.
Closed Mar 30, 2009 at 9:37 PM by henkoberholzer


Suneel wrote Nov 17, 2008 at 1:36 PM

My recommendation for changing to 'nonNegativeInteger' also fails since the type varbinary(max) has a MaxLength of '-1'.

Suneel wrote Nov 17, 2008 at 1:41 PM

Another issue exists in that the at least one ProcedureParameter must exist. There are many cases for using Stored Procedures without parameters and hence the element definition should be:

<xs:element maxOccurs="unbounded" name="ProcedureParameter" minOccurs="0">

wrote Feb 6, 2009 at 1:10 PM

wrote Mar 30, 2009 at 9:37 PM

wrote Feb 1, 2013 at 3:05 AM

wrote May 8, 2013 at 5:47 PM