[R] RE: ROracle package error - Solution

[Joan Snodgrass]

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

Regards, 
Joan

-----Original Message-----
From: Joan Snodgrass [mailto:joans at breastcenter.tmc.edu] 
Sent: Tuesday, May 11, 2004 10:54 AM
To: 'r-help at 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
9.2.0.4. 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'
ROracle_0.5-4.tar.gz

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
appreciated!

Regards, 
Joan 

Joan Snodgrass <joans at breastcenter.tmc.edu>