similar to: ROracle installation problem

Hello, I am trying to configure my system with ROracle. I am running RHEL 3 AS x86_64. I have the Oracle client 9.2.0.4 x86_64. I have successfully compiled and run both R-1.8.1 and R-1.9.0 (tried ROracle on both installations). I am using DBI 1.8 and ROracle 0.5-4. I have used both the default Redhat installed gcc 3.2.3 and gcc 3.4. I am able to compile ROracle successfully with the

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

Hi I Can't connect to the Oracle database, any tips? Has anybody actually got ROracle up and running on windows? >> unable to find an inherited method for function "dbConnect", for signature "OraDriver" I can happily connect to the same database through RODBC. Oracle client, version 9.2 installed, amongst others. Sean > library(DBI) > library(ROracle)

Hi all - I am trying to install ROracle for linux machines ... I have read the INSTALL documentation and followed the directions for setting the paths as follows: export PATH=/app/oracle/product/10.2.0/db_1/bin:$PATH [manthony@diamondback ~]$ export LD_LIBRARY_PATH=/usr/lib:/usr/lib64:/lib:/app/oracle/product/10.1.0/db_1

Hello, I am trying to compile ROracle _0.5-4 under R 1.9.0 without much success. I am running Windows 2000 SP4, Visual C++ 6.0 SP6, and Oracle client 9.2.0.1.0. I was able to run the pre-compiled version of ROracle_0.5-2 under R 1.7.1, but does not work on R 1.8.1 or R 1.9.0. Here is the output from nmake: C:\Program Files\R\rw1090\library\ROracle\src>nmake Microsoft (R) Program

Hi, I am new to R. I need to communicate with Oracle from R program in windows xp. So I am planning to use ROracle. I downloaded the ROracle src from the site below: http://cran.r-project.org/web/packages/ROracle/index.html I am using R version 2.6.2 and Oracle 10g. I followed the instructions to build ROracle. When I try to compile the source src/Makefile.win I get the following error:

Hi, I need to use ROracle to communicate with Oracle from R program in windows environment. I am using Oracle 10g, R 2.6.2. I found a pre-compiled binary for ROracle for Oracle version 9.2. When I am trying to use it with Oracle 10g I get the following error: con <- dbConnect(drv, "user/passwd at dbname"); Error in function (classes, fdef, mtable) : unable to find an inherited

Dear R-users, I was able to make ROracle package to connect to the DB (Oracle91, 64bit, on Solaris). But after executing siple SQL query, "fetch" commaned gives me an empty dataframe. ### RORACLE INSTALATION PROCEDURE ### R CMD INSTALL --configure-args='--enable-extralibs' --enable-oracle32=no ~/tmp/ROracle_0.5-5.tar.gz #since we have 64bit Oracle9i instalation PROBLEM:

Hi, trying ROracle failed? I'm using Oracle.8.1.7 which is on another machine. With Tora i get access to the database what i wish to get with R-Project, too. What does the message mean? "Oracle pre-compiler proc not in /opt/oracle/OraHome1/bin/proc you may not be able to compile ROracle" I'm using linux sue9 and R.1.8.1. many thanks for any help! [snip]

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

Hi, I have a problem executing "library(ROracle)" in R: OS/Software: Redhat 8.0, all available patches applied Oracle 9i v9.2.0.1.0 R v1.7.0 ROracle v0.5-0 DBI v0.1-5 The compilation and installation of ROracle went fine. However when I try to load ROracle I get the following: >> library(ROracle) >Error in dyn.load(x, as.logical(local), as.logical(now)) : > unable

I am running R 2.0.0 on a SunOs 5.9 machine and using Oracle 8i.1.7.0.0 (enterprise edition) and when I try to load ROracle I receive the following error: "require(ROracle) Loading required package: ROracle Loading required package: DBI Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library

Hi, first thanks to Sunny Ho (and David James for the pointer) for resolving the problem of the empty rows returned from ROracle. However, I have a problem still: > library(ROracle) > ora <- dbDriver("Oracle") > con <- dbConnect(ora, user = USER, password = PWD, dbname = DBNAME) > rs <- dbExecStatement(con, "select * from USER_TABLES") Error in

Dear list. Has anybody had any issues with ROracle, namely consistently leading to a segmentation fault? One of our oracle databases seems to have certain issues at the moment (do not know what exactly though) and if that one is queried ROracle definitely fails with a segmentation fault. Any ideas? Here is the trace and below is also a type of query that crashes it: *** caught segfault ***

Howdy, When doing a install.packages("ROracle") in R I'm getting the following error: R CMD COMPILE RS-DBI.c make[1]: Entering directory `/tmp/R.INSTALL.1809/ROracle/src' gcc -I/usr/lib/R/include -I/usr/local/include -D__NO_MATH_INLINES -mieee-fp -fPIC -O2 -m486 -fno-strength-reduce -g -c RS-DBI.c -o RS-DBI.o make[1]: Leaving directory `/tmp/R.INSTALL.1809/ROracle/src'

I've seen from earlier posts that other people had problems installing ROracle under Windows. I run R-2.3.1. I got the Windows binaries for ROracle from http://stat.bell-labs.com/RS-DBI/download/index.html Here is my session: > require(ROracle) Loading required package: ROracle Loading required package: DBI [1] TRUE > drv <- dbDriver("Oracle") > drv

Context: Pentium 4 with FreeBSD 5.4 and R 2.2.0 I'm trying to install the package ROracle under R. To start with I installed the oracle8- client from the ports and referred to it via the variable $HOME_ORACLE as /usr/local/oracle8-client. Then I started R. After issuing install. packages("ROracle") R downloaded the needed package and started to compile it but complained:

Hello, I have installed the ROracle and DBI packages, and I want to access an Oracle database that is not on the same machine as the one I am running R on. I can access the database remotely with perl DBI and Java JDBC. Does anyone know if this is possible using R DBI/ROracle ? I have looked through the documentation and also tried to guess at things which might work, but with no success. I

Hi, Has anyone seen this problem before, and does anyone have a solution? When I query a database using DBI and ROracle to retrieve a date in a format other than the system default, I get a core dump. System: Redhat Linux 7.3 uname: Linux 2.4.20-20.7smp #1 SMP Mon Aug 18 14:46:14 EDT 2003 i686 Oracle version 8i R --version: R 1.7.1 (2003-06-16). DBI_0.1-6, ROracle_0.5-0 Start up R, load

Hi all!! I would like to know if anyone has experienced this behaviour with ROracle package. I'm attaching information to reproduce the issue. Bug maybe? Thank you very much for your attention. Ramon. ################################################################## ################################################################## oraExecStatement BUG : RS-DBI driver: (ORA-02005: