But the question was "What is the error in this situation ?" i.e. the sample code provided. Anyway, no value is assigned to @retval in your new proc so it...

You can use the substring & cast functions to extract the data from the varchar columns as the positions of the data appear to be fixed. You could then extract...

'Nothing' should only be used when dealing with object and in VB, an array is not an object. So checking if aParams(0) is nothing will cause an error if the...

Not sure if this is the right forum either but anyway... The ADO Command class has a Parameters collection whose members can be accessed by name. You can add them...