[R] RE: ROracle package error - Solution

About this list Date view Thread view Subject view Author view Attachment view

From: Joan Snodgrass (joans@breastcenter.tmc.edu)
Date: Wed 12 May 2004 - 23:59:40 EST

Message-id: <001101c43829$5e9f76a0$4c38f980@ad.bcm.edu>

Thank you to David James for the solution to this one!

David James wrote:
> The workaround in the README.Oracle9 files is intended for the symbol
> sqlda (I think), but the sqlctx symbol apparently is defined in
> -lclntsh.
> So, could you try the following?

R CMD INSTALL --configure-args='--enable-oracle32
--enable-extralibs="-lsqlplus -lclntsh"' ROracle_0.5-4.tar.gz


-----Original Message-----
From: Joan Snodgrass [mailto:joans@breastcenter.tmc.edu]
Sent: Tuesday, May 11, 2004 10:54 AM
To: 'r-help@stat.math.ethz.ch'
Subject: ROracle package error

I am running R 1.8.1 on a Solaris 8 64-bit machine and using Oracle I noticed that the readme for ROracle lists a problem and
suggests the following to work around it:
R CMD INSTALL --configure-args='--enable-extralibs' ROracle_0.5-4.tar.gz

I ran the following to install since we have 32-bit R and 64-bit Oracle:
R CMD INSTALL --configure-args='--enable-oracle32--enable-extralibs'

I receive no errors during the install, but when I try to load the
package I receive the following error (which is very similar to the one
listed in the readme):
> library(ROracle)
Error in dyn.load(x, as.logical(local), as.logical(now)) :
unable to load shared library "/usr/local/lib/R/library/ROracle/libs/ROr
acle.so": ld.so.1: /usr/local/lib/R/bin/R.bin: fatal: relocation error:
file /usr/local/lib/R/library/ROracle/libs/ROracle.so: symbol sqlcxt:
referenced symbol not found
Error in library(ROracle) : .First.lib failed

Has anyone else experienced this? Any help would be greatly


Joan Snodgrass <joans@breastcenter.tmc.edu>

R-help@stat.math.ethz.ch mailing list
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

About this list Date view Thread view Subject view Author view Attachment view

This archive was generated by hypermail 2.1.3 : Mon 31 May 2004 - 23:05:09 EST