R连接oracle数据库Error in odbcFetchRows negative length vectors are not allowed解决方法

问题:

R连接oracle数据库Error in odbcFetchRows negative length vectors are not allowed解决方法

解决方法:配置ODBC连接时,对于oracle和Sybase驱动需要设置参数believeNRows=FALSE

R连接oracle数据库Error in odbcFetchRows negative length vectors are not allowed解决方法

参数believeNRows说明:logical. Is the number of rows returned by the ODBC connection believable? Not true for some Oracle and Sybase drivers, apparently, nor for Actual Technologies' SQLite driver for Mac OS X.