Re: [R] [ROracle] error loading (undefined symbol: sqlclu)
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.
[R] [ROracle] error loading (undefined symbol: sqlclu)
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 __ 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.
[R] ROracle installation problem with R2.2
Hi, I just installed R version 2.2.1, I installed DBI package and worked fine and then I installed ROracle but I got this error: [EMAIL PROTECTED] bin]$ R CMD INSTALL --configure-args='--enable-extralibs' ../../ROracle_0.5-5.tar.gz * Installing *source* package 'ROracle' ... creating cache ./config.cache checking how to run the C preprocessor... cc -E updating cache ./config.cache creating ./config.status creating src/Makevars sed: file conftest.s1 line 29: Unterminated `s' command creating src/Makefile sed: file conftest.s1 line 29: Unterminated `s' command ** libs make: *** No targets. Stop. ERROR: compilation failed for package 'ROracle' ** Removing '/home/drapeau/download/R-2.2.1/library/ROracle' Any idea what could cause this problem? I used to install the same ROracle version with R version 1.9 and it worked. Thanks, Mathieu __ 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
[R] ROracle and select query empty
I am using Linux Oracle Client 9i and I am running my R scripts on a Linux box. I logged on our Oracle administration interface and the queries that I launched were executed and returned many lines directly to my Linux box. It looks that the problem is with the fetch method. Thank you very much, Mathieu Mathieu Drapeau mathieu.drapeau at mcgill.ca https://stat.ethz.ch/mailman/listinfo/r-help wrote: / Hi, / / I just installed ROracle and RDBI. The connection to the database seems / / to work also. My problem is when I am selection rows that really exist / / in the database, it is returning nothing. Where should I look to see / / what could be my problem? / What platform are you running R on? And what version of Oracle? This sounds very familiar... are you building ROracle on Linux? -- David Hinds __ 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
Re: [R] ROracle and select query empty
Thanks!!! It is working now. Mathieu [EMAIL PROTECTED] wrote: Mathieu Drapeau [EMAIL PROTECTED] wrote: I am using Linux Oracle Client 9i and I am running my R scripts on a Linux box. Does /usr/include/sqlca.h exist? This is a Postgres file. My hazy memory is that this conflicts with an Oracle header; and that if ROracle sees this one at compile time, you get empty query results. Try renaming this file to something else, then rebuild ROracle. -- Dave __ 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 __ 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
[R] ROracle and select query empty
Hi, I just installed ROracle and RDBI. The connection to the database seems to work also. My problem is when I am selection rows that really exist in the database, it is returning nothing. Where should I look to see what could be my problem? Thank you very much, Mathieu drv - dbDriver(Oracle) summary(drv, verbose=TRUE) OraDriver:(6721) Driver name: Oracle (ProC/C++) Max connections: 10 Conn. processed: 8 Default records per fetch: 500 Oracle R/S client version: 0.5-4 RS-DBI version: 0.1-9 Open connections: 2 1 OraConnection:(6721,0) 2 OraConnection:(6721,7) conn - dbConnect(drv, mathieu/[EMAIL PROTECTED]) summary(conn, verbose=TRUE) OraConnection:(6721,7) User: mathieu Dbname: MYDB Oracle Server version: rs - dbSendQuery(conn, statement = paste(select * from cat)) summary(rs, verbose=TRUE) OraResult:(6721,7,2) Statement: select * from cat Has completed? no Affected rows: 0 Rows fetched: -1 Fields: nameSclass type len precision scale isVarLength nullOK 1 TABLE_NAME character VARCHAR2 30 0 0TRUE FALSE 2 TABLE_TYPE character VARCHAR2 11 0 0TRUE TRUE myContent - fetch(rs, n = -1) myContent [1] TABLE_NAME TABLE_TYPE 0 rows (or 0-length row.names) summary(myContent, verbose=TRUE) TABLE_NAME TABLE_TYPE Length:0 Length:0 Class :character Class :character Mode :character Mode :character summary(rs, verbose=TRUE) OraResult:(6721,7,2) Statement: select * from cat Has completed? yes Affected rows: 0 Rows fetched: -1 Fields: nameSclass type len precision scale isVarLength nullOK 1 TABLE_NAME character VARCHAR2 30 0 0TRUE FALSE 2 TABLE_TYPE character VARCHAR2 11 0 0TRUE TRUE __ 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
[R] ROracle installation problem
Hi there, I am trying to install ROracle but I get this error. I have an error in reconcilePropertiesAndPrototype. (My LD_LIBRARY_PATH is set with the oracle lib) Thanks, Mathieu # R CMD INSTALL --configure-args='--enable-extralibs' ../ROracle_0.5-5.tar.gz * Installing *source* package 'ROracle' ... creating cache ./config.cache checking how to run the C preprocessor... cc -E updating cache ./config.cache creating ./config.status creating src/Makevars creating src/Makefile ** libs R CMD COMPILE RS-DBI.c make[1]: Entering directory `/tmp/R.INSTALL.10940/ROracle/src' gcc -I/usr/lib/R/include -I/usr/local/include -D__NO_MATH_INLINES -mieee-fp -fPIC -O2 -g -pipe -march=i386 -mcpu=i686 -c RS-DBI.c -o RS-DBI.o make[1]: Leaving directory `/tmp/R.INSTALL.10940/ROracle/src' proc CODE=ANSI_C MODE=ORACLE INCLUDE=/usr/lib/R/include \ PARSE=NONE LINES=false RS-Oracle.pc Pro*C/C++: Release 9.2.0.1.0 - Production on Tue Aug 23 10:43:25 2005 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. System default option values taken from: /opt/oracle/product/9.2.0/precomp/admin/pcscfg.cfg R CMD COMPILE RS-Oracle.c make[1]: Entering directory `/tmp/R.INSTALL.10940/ROracle/src' gcc -I/usr/lib/R/include -I/usr/local/include -D__NO_MATH_INLINES -mieee-fp -fPIC -O2 -g -pipe -march=i386 -mcpu=i686 -c RS-Oracle.c -o RS-Oracle.o make[1]: Leaving directory `/tmp/R.INSTALL.10940/ROracle/src' R CMD SHLIB -o ROracle.so RS-DBI.o RS-Oracle.o make[1]: Entering directory `/tmp/R.INSTALL.10940/ROracle/src' gcc -shared -L/usr/local/lib -o ROracle.so RS-DBI.o RS-Oracle.o -L/opt/oracle/product/9.2.0/lib -L/opt/oracle/product/9.2.0/network/lib -lclntst9 -lnbeq9 -lnhost9 -lnus9 -lnldap9 -lldapclnt9 -lnsslb9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9 -lntcp9 -lntns9 -ldl -lm -lpthread -lnsl -ldl -lm -lsqlplus make[1]: Leaving directory `/tmp/R.INSTALL.10940/ROracle/src' ** R ** inst ** save image [1] TRUE Loading required package: DBI [1] FALSE Warning message: There is no package called 'DBI' in: library(package, character.only = TRUE, logical = TRUE, warn.conflicts = warn.conflicts, [1] dbObjectId Creating a new generic function for format in ROracle [1] format [1] show Creating a new generic function for print in ROracle [1] print Error in reconcilePropertiesAndPrototype(name, slots, prototype, superClasses, : Class DBIPreparedStatement extends an undefined class (DBIObject Execution halted /usr/lib/R/bin/INSTALL: line 1: 11177 Broken pipe cat /usr/lib/R/library/ROracle/R/ROracle ERROR: execution of package source for 'ROracle' failed ** Removing '/usr/lib/R/library/ROracle' __ 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
[R] histogram density division
Hi, I already sent this query but I didn't receive any answers. I try another time and try to explain another way my question... I want to decrease the height of my bands in my histogram by a factor of 5... how can I do that? Is there an argument to hist() that do the job? Thanks, Mathieu Hi, I would like to plot an histogram with modified density values. My Y-axis represent the occurences of the ranges (specified by the breaks argument) of my data (represented by a big vector). Now, I would like to divide by X the number of occurences in each bands and do a plot of lower occurences. How can I do that? Thanks, Mathieu __ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help
[R] histogram density division
Hi, I would like to plot an histogram with modified density values. My Y-axis represent the occurences of the ranges (specified by the breaks argument) of my data (represented by a big vector). Now, I would like to divide by X the number of occurences in each bands and do a plot of lower occurences. How can I do that? Thanks, Mathieu __ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help
[R] hist plot and custom band width
Hi, I have some difficulties to figure how to set a range to my histogram bands. I have values that are [0,50] and they appear once in my list. How can I do a histogram that include all the values between a range of 1 together? [0,1],[10001,2],[21,3], ... Thanks, Mathieu __ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help
[R] R input file scanning
Hi, I would like to know how can I solve my problem... I want to load some data (surrounded by a tag) that are stored in a file that contains also some scrap (header and descriptions) that I want to skip. How can I do that? Thanks, Mathieu __ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help
[R] generic function object
Hi, I would like to know if there is a way to see the code of a generic function? Like when I only type the function name, it prints the source of that function. But I cannot see the code of a generic function, it prints: ... function (object, ...) standardGeneric(normalize) environment: 0x8e9e368 Methods may be defined for arguments: object ... Thanks, Mathieu __ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help