similar to: ROracle package error

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:

Dear R users, I'm working on implementation of hydrometeorological DB in Oracle9i and would like to use R, as a plotting engine for graphs and maps and also to perform some non trivial statistics on DB data using R. Thus any links with examples or efforts on: - general DB and R cooperation - Oracle91 and R cooperation - Oracle PL/SQL and R are welcomed. Thanks in advance, Rado --

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

Sorry for posting the second time, I corrected the SQL code: PROBLEM: after executing simple statement, from within R, "fetch" function gives me the empty dataframe: ### CONNECTION, and SQL QUERY EXECUTION > ora <- dbDriver("Oracle") > con <- dbConnect(ora, "rado/only2admin" > dbListTables(con) character(0) > rs <- dbSendQuery(con,

Hello, Someone posted this same issue back in May 2003 and hasn't yet resolved the situation. I hope someone can provide some additional light. After starting R I attempt to load the ROracle library and receive the following message: > library(ROracle) Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library

Hi All, If you had run into the problem with ROracle on Linux: "fetch() returns zero rows or empty dataset", here is an easy & safe work-around for you to try out. It works for me, and very likely it will work for you too. You must have root privilege to do this on your machine. Quick Instructions Part 1 - Check to see if this is the work-around for you a) log in as

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:

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, 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 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 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 had problem during SJava and ROracle installation. I use "R CMD INSTALL -c SJava_0.65-0.tar.gz" command to install SJava pakage. After installation, I start R session and type library(SJava), error happened as: > library(SJava) Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library

Hello everybody. I'm a newbie in R in a debian and linux in general I'm trying install roracle in my debian 64 bit system. I've read the http://cran.r-project.org/web/packages/ROracle/INSTALL and I've installed Oracel Instant Client by rpm package (using alien to deb convert). When I try to install I write export

Hello, I am running Linux, I have downloaded instantclient-basiclite-linux32-11.2.0.2.0.zip instantclient-sqlplus-linux32-11.2.0.2.0.zip instantclient-sdk-linux32-11.2.0.2.0.zip instantclient-precomp-linux32-11.2.0.2.0.zip All these tarballs are unzipped in /usr/local/lib/instantclient, I have added this path in the library path of the host. I can run sqlplus and proc, they do not complain

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 tried to install ROracle package (Windows XP pro), got the following errors; *C:\Program Files\R\R-2.6.2\bin>rcmd install "c:\ROracle_0.5-9.tar.gz"* * installing to 'c:/PROGRA~1/R/R-26~1.2/library'* *---------- Making package roracle ------------* * ********************************************** WARNING: this package has a configure script It

Buenas. Necesito conectarme a una BD Oracle desde linux debian y estoy probando a instalar el paquete ROracle para usar la misma forma de conectarme que tenía cuando usaban postgres. El tema es que al instalarlo me dice * installing *source* package ?ROracle? ... ** package ?ROracle? successfully unpacked and MD5 sums checked configure: error: OCI libraries not found ERROR: configuration failed

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, 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

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