We connect R c Oracle using the ROracle library. Some requests work without problems. But most select requests fail with an ORA-30204 error: buffer is not large enougth.

The same queries in SQL Developer work without errors. Previously used the RJDBC library. It works much slower, but work out requests. Tell me, please, how to get rid of the error that appears.

  • How do you make select using dbGetQuery? look at the parameters of bulk_read - Batanichek
  • Used dbGetQuery. Experiments with the bulk_read option did not lead to success. And dbSendQuery, in fact, crashes with the same error. - D.Seledkov
  • And if at the same time try to put prefetch = TRUE in dbconnect? - Batanichek
  • Thank you for your comment. Consider if we encounter something similar in the future. - D.Seledkov

1 answer 1

The solution turned out to be where no one would think to look for it. The ORA-30204 error was created by the presence of a Russian-language comment in the SQL query text. After the removal of Russian comments, requests began to work. Those. you need to either change the encoding settings, or abandon the Cyrillic alphabet.