In VB6.0 we use the command object and the parameter type as output

For eg:

objComd.Parameters.Append objComd.CreateParameter(, adInteger, adParamOutput, 10)

we can put as many parameters as possible

Did you try and run the SP seperately?

Thanks guys ,

Now I know what  they mean when they say post a question and get the point of views.

The answers have really helped me.I hope soon I'll also be able...