Error previewing SQL query

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

1 Like