Skip to content
Prev 791 / 1559 Next

RODBC and Oracle 11g Issue.....

On Mar 4, 2010, at 7:07 PM, Joe O wrote:

            
Hi,

In your calls to odbcConnect() and sqlQuery() try using 'rows_at_time = 1':

  channel <- odbcConnect("OracleLocal", uid="parts", pwd="parts", rows_at_time = 1)
  sqlQuery(channel, "select distinct segment from parts", errors=TRUE, rows_at_time = 1)

In the recent versions of RODBC, the default for rows_at_time is now 100, which has been known to cause problems on certain systems, Oracle being one. On my system, which is OSX 10.6.2 connecting to Oracle 11g on RHEL with RODBC, I need to make this adjustment in order to get reliable query results. This is touched on in the Details section of ?sqlQuery.

HTH,

Marc Schwartz