ParameterCollectionType Data Type

The enum ParameterCollectionType Collection type of a parameter has to be chosen based on its context. - If it is occurring next to an IN/NOT IN clause, its multiple - If it is found with EQ/NEQ..>,<,>=,<=,like etc, its single

value description
SINGLE Single valued parameter.
MULTIPLE Multivalued parameter.