Made sure DbType is set for the command parameter before setting the value of the parameter to minimize value out range exceptions from ODP.