I'm limiting this issue to using parameters within an insert select. Since the parameter types are able to be inferred, there are no casting requirements. However, using a parameter in a select clause, without a select, may require casting and should be investigated with a follow up. If someone is interested, that is