Passing parameter that is not used in the query throws error

[utoracle]

I am evaluating dotConnect for Oracle and there is a use case where I pass parameters to the query even though the parameter is not used in the actual SQL query.

I have tried setting PassParametersByName property to true but it doesn't work. I get the error - ORA-01036: illegal variable name/number.

Is there a workaround for this?

[Pinturiccio]

This is the designed behaviour. You should have the same number of parameters and the same parameter names as in your query. If you have more or less parameters, Oracle generates the ORA-01036 error.