问题描述
我正在尝试使用install.packages("ROracle")安装ROracle软件包，但是每次收到此消息"Package which is only available in source form, and may need compilation of C/C++/Fortran: ‘ROracle’"
I am trying to install ROracle package using install.packages("ROracle") but every time i am getting this message "Package which is only available in source form, and may need compilation of C/C++/Fortran: ‘ROracle’"
These will not be installed
我无法为此找到解决方案，我该如何解决此问题?
I am not able to find the solution for this, How can i resolve this issue?
推荐答案
来自过去的帖子.如何在Windows 7上安装ROracle软件包?
从oracle下载二进制文件: http://www.oracle.com/technetwork/database/database-technologies/r/roracle/downloads/index.html
Download binary from oracle: http://www.oracle.com/technetwork/database/database-technologies/r/roracle/downloads/index.html
在r中运行以下命令，替换文件路径:
The run the following command in r, substituting the file path:
setwd('xxxxx') # set to path of download
install.packages('ROracle_1.2-1.zip', repos = NULL)
Then load the library and use the package - you may have to change XXXX to whatever is in your TNS Names:
library('ROracle')
drv <- dbDriver("Oracle")
con <- dbConnect(drv, "USER GOES HERE", "PASSWORD GOES HERE", dbname='XXX')
test connection:
dbReadTable(con, 'DUAL')
能够从源代码安装并直接从oracle下载预编译的插件
was able to install from source and download the pre compiled addin directly from oracle
这篇关于如何安装ROracle软件包?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！