Hi Marc, thanks for the answer, but that wasn't the problem. I set my LD_LIBRARY_PATH in my .cshrc.
I solve my problem by compiling the library manually. It created me a file (ROracle.so) of ~14mb (instead of the one of ~150K) that I replaced with the other one. I guess R compilation did something wrong. Thanks, Mathieu Marc Schwartz (via MN) wrote: >On Wed, 2006-09-20 at 15:15 -0400, Mathieu Drapeau wrote: > > >>I have this error when I load the library ROracle: >> >> >>>library(ROracle) >>> >>> >>Loading required package: DBI >>Error in dyn.load(x, as.logical(local), as.logical(now)) : >> unable to load shared library >>'/usr/local/lib/R/site-library/ROracle/libs/ROracle.so': >> /usr/local/lib/R/site-library/ROracle/libs/ROracle.so: undefined >>symbol: sqlclu >>Error in library(ROracle) : .First.lib failed for 'ROracle' >> >> >>Also, my LD_LIBRARY_PATH seems to be set correctly: >>drapeau:~> echo $LD_LIBRARY_PATH >>/home/drapeau/lib:/opt/oracle/xe/app/oracle/product/10.2.0/client/lib >> >>I installed the big database applications (10g) and ROracle 0.5-7 >> >>Your help will be very appreciated to help me solve this error, >>Thank you, >>Mathieu >> >> > >Where did you set LD_LIBRARY_PATH? > >If in one of your shell config files, it is likely that it is being >stepped on during your login and thus not being seen within the R >session. > >I had this problem previously and set the variable in /etc/ld.so.conf >(though I am using RODBC instead). > >Edit that file (as root), add the path: > >/opt/oracle/xe/app/oracle/product/10.2.0/client/lib > >and then run [/sbin/]ldconfig to update the current settings. > >Be sure also that $ORACLE_HOME is set >to /opt/oracle/xe/app/oracle/product/10.2.0/client > >Then try to load ROracle in a new R session. > >HTH, > >Marc Schwartz > > > > > ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
