In case like this, I would try to identify where the issue comes from. R or SQL.
Does the SQL script work outside of RStudio ? Without dplyr I mean, if you query directly using ODBC driver.
Also, if possible you could try ROracle, it works with the OCI driver not odbc and in the past I found some difference on very specific data type in our DB.
It just some wild guesses as you did not provide much information to help us help you. I would be great if you manage to build an example and show whet you've tried. Just showing an error message if often not enough. Thanks!
FAQ helper: FAQ: Tips for writing R-related questions