Hi you can give the max size as per ur requirement. But you have to follow while declaring the size of the parameter is not less than than the size of the parameter that u have declared in your stored proc's