One way to prevent "operand type clash" errors is to use a two-dimensional parameter array to pass parameters to the stored procedure. The stored procedure parameters should have default values (most likely NULL).