[R-sig-DB] calloc error using RODBC and Oracle
Brian Klaassens
br|@n_k|@@@@en@ @end|ng |rom bd@com
Thu Jul 9 18:34:47 CEST 2015
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]]
More information about the R-sig-DB
mailing list