similar to: Oracle RODBC/ROracle(W2k)

I have success with compiling and installation on R-1.7.1 with ROracle_0.5-0.tar.gz.tar But starting the first tests i get this error ? >> >>library(DBI) >>library(ROracle) >> >>drv <- dbDriver("Oracle") Error in .Call("RS_Ora_init", config.params, reload, PACKAGE = .OraPkgName) : .Call function name not in load table Perhaps it is

Hi, i have R on ubuntu64 i got ROracle database connection issues as seen below at a loss do to what next > library(ROracle) Loading required package: DBI > m <- dbDriver("Oracle") > con <- dbConnect(m, username="EPICEDF", password="ps39000b", dbname="EPICD2007", address="10.1.16.40") Error in oraNewConnection(drv, ...) : unused

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

Hi everyone, I have been following these forums closely for the last few months but this is my first time posting. Basically I am trying to get an Oracle SQL Developer Binary Large Object(BLOB/CLOB) file in as an R object in R. For those not familiar with a BLOB/CLOB file, it is basically lik a table that has cells that contain tables or files. By converting the large table into a BLOB/CLOB file

Hi, I've just installed the ROracle package. The library loads okay but when I try to instantiate a database manager I get an error: > ora <- dbManager("Oracle") Error in .Call("RS_Ora_init", config.params, reload) : .Call function name not in load table Has anyone had any experience with using this package? Regards, Gavin Kennedy Software Engineer -

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

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

Hello, Attached is a mail regarding question how to insert Date field using ROracle package. I am stuck with this problem and appreciate receiving help from gurus on this list. Code used mainly is: library(ROracle) ### --- Version 0.53 drv <- dbDriver("Oracle") con <- dbConnect( drv, "user/passwd") d <- data.frame(CDATE = "2004-03-10 10:12:00") ps

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:

Dear R-users, In order to use ROracle (v. 0.5-5) package I compiled R-1.9.1 on Linux (2.4.20-28.9smp) and installed it. I need to use Oracle9i on Solaris. When executing "library(ROracle)" I got the following error message: > library(ROracle) Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library

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

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

Dear R-users, here is an error that you might encounter when using ROracle. > library(ROracle) Loading required package: DBI > con <- dbConnect(dbDriver("Oracle"), "mkienzle/******@tabs") > dbListTables(con) ********** Internal heap ERROR 17177 addr=0x0 ********* ****************************************************** HEAP DUMP heap name="Alloc

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

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

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