ROracle Not installing for R 4.0

[robertoromo]

I recently moved to R 4.0. In installing new packages, I cannot get ROracle to install in latest version. The ROracle-1.3.2.zip works for R 3.6.0 and not R 4.0. What have other ROracle users done to connect R 4.0 with Oracle?

I also tried installing via CRAM source with no luck. I got this

Error: package or namespace load failed for ‘ROracle’:
package ‘ROracle’ was installed before R 4.0.0: please re-install it

[andresrcs]

We need more information to help you, please post the complete output you get when you run

install.packages("ROracle")

[robertoromo]

This is what I get.

"Package which is only available in source form, and may need compilation of C/C++/Fortran: ‘ROracle’"

Then I download the tar file from CRAN and install from source using

install.packages("location", repos = NULL, type="source")

and I get:

Error: package or namespace load failed for ‘ROracle’:
package ‘ROracle’ was installed before R 4.0.0: please re-install it

I also notice Oracle has not update the package they maintain the latest is for R 3.6.0

https://www.oracle.com/database/technologies/roracle-downloads.html