I'm trying to compile ROracle 1.3-1 on Windows 10 and R 3.5.2 and I'm getting this error:
Error: package or namespace load failed for 'ROracle' in inDL(x, as.logical(local), as.logical(now), ...):
unable to load shared object 'C:/XXXXXXXXXXX/RLibs/ROracle/libs/x64/ROracle.dll':
LoadLibrary failure: The specified module could not be found.
I have the following environment variables set, as per the installation instructions:
OCI_LIB64 = c:/oreclient/instantclient_12_2
Path = c:/Rtools/bin;c:/oreclient_instantclient_12_2; etc
Additionally, I have tried both with and without
OCI_INC = c:/oreclient/instantclient_12_2/sdk/include
In all cases, early in the compiling I see messages like:
found Oracle Client C:\oreclient\instantclient_12_2
found Oracle Client include c:\oreclient\instantclient_12_2\sdk\include
indicating that the environment variables have been found.
I have tried using different instantclient versions in combination with older versions of ROracle, always with the same result as above.
I have tried downloading the Windows binary from Oracle and that installation fails with this error:
> install.packages("ROracle-1.3.1.zip",repos = NULL)
Installing package into ‘C:/XXXXXXXXXXXXXX/RLibs’
(as ‘lib’ is unspecified)
Warning in install.packages :
cannot open compressed file 'ROracle-1.3.1/DESCRIPTION', probable reason 'No such file or directory'
Error in install.packages : cannot open the connection
Any suggestions on the actual correct way to compile the package, since nothing in the instructions seems to work at all?