[R-sig-DB] calloc error using RODBC and Oracle

[Brian Klaassens]

Trying to get RODBC to work on SUSE Linux Enterprise Server 11 (x86_64)
When I run a quick test script like this
=======================================================
library(RODBC)
odbChannel <- odbcConnect(dsn = "CTPRD03", uid = "*********", pwd = "*******")
odbcGetInfo(odbChannel)
df.test <- sqlQuery(channel = odbChannel, query = "select * from DUAL;")
df.test
close(odbChannel)
========================================================

I get the following results:
========================================================
shiny using narc07shiny1dev>Rscript R_SIMPLE_ODBC_TEST.r
       DBMS_Name         DBMS_Ver  Driver_ODBC_Ver Data_Source_Name
        "Oracle"     "11.02.0030"          "03.52"        "CTPRD03"
     Driver_Name       Driver_Ver         ODBC_Ver      Server_Name
   "SQORA32.DLL"     "11.02.0004"          "03.52"        "CTPRD03"
Error in odbcQuery(channel, query, rows_at_time) :
  'Calloc' could not allocate memory (18446744073709551616 of 22816 bytes)
Calls: sqlQuery -> odbcQuery -> .Call
Execution halted
Warning message:
closing unused RODBC handle 1
=========================================================


Isql works fine
=========================================================
shiny using narc07shiny1dev>isql CTPRD03
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> select * from dual;
+------+
| DUMMY|
+------+
| X    |
+------+
SQLRowCount returns -1
1 rows fetched
=========================================================


Reinstalled RODBC based on previous suggestion in the mailing list and did not resolve the issue.
Not sure where to go from here, looking for suggestions?


**********************************************************************
*******************************************************************
IMPORTANT MESSAGE FOR RECIPIENTS IN THE U.S.A.:
This message may constitute an advertisement of a BD group's products or services or a solicitation of interest in them. If this is such a message and you would like to opt out of receiving future advertisements or solicitations from this BD group, please forward this e-mail to optoutbygroup using bd.com.
*******************************************************************
This message (which includes any attachments) is intended only for the designated recipient(s).  It may contain confidential or proprietary information and may be subject to the attorney-client
privilege or other confidentiality protections.  If you are not a designated recipient, you may not review, use, copy or distribute this message. If you received this in error, please notify the sender by reply e-mail and delete this message. Thank you.
*******************************************************************
Corporate Headquarters Mailing Address: BD (Becton, Dickinson and Company) 1 Becton Drive Franklin Lakes, NJ 07417 U.S.A.

	[[alternative HTML version deleted]]