similar to: Database Connectivity Performance Comparison with ROracle

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

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 the access to Oracle via ODBC in Win2k/1.8.1 i have only 2 problems. (1) number(x,y) formats in oracle result in R-Project as a factor with more than 20.000 levels for every distinct value. My coversion attempts until now failed, i.e. as.numeric(money) result in a: Error in as.double.default(money) : (list) object cannot coerced to double (2) A attempt to save a data.frame

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

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

I have not devoted time to setting up ROracle since binaries are not available and it seems to require some effort to compile (see http://cran.r-project.org/web/packages/ROracle/index.html). On the other hand, RODBC worked more or less magically once I set up the data sources. What is your success using ROracle and why would it be preferable to RODBC ? -Avram On Thursday, September 11,

I need help. I'm trying to connect with an Oracle DBMS and MySQL DBMS, I'm using RJDBC package. My code is the next: library('rJava') library('DBI') library('RJDBC') //Mysql drv <- JDBC("com.mysql.jdbc.Driver","C:\\Temporal\\mysql-connector-java-3.0.9-stable-bin.jar","'") conn <- dbConnect(drv,

Con oracle puedes usar, si tu máquina es de 64bits la librería Roracle que va muy bien y no es muy complicada de instalar. Hay que distinguir 2 cosas, cuando accedes a la base de datos y allí haces la consulta, eso da igual si lo haces con RODBC o Roracle y cuando cargas los datos en tu data.frame, en esta operación, ya no está usando el gestor de base de datos sino tu propio R. La velocidad y

I need help. I'm trying to connect with an Oracle DBMS and MySQL DBMS, I'm using RJDBC package. My code is the next: library('rJava') library('DBI') library('RJDBC') //Mysql drv <- JDBC("com.mysql.jdbc.Driver","C:\\Temporal\\mysql-connector-java-3.0.9-stable-bin.jar","'") conn <- dbConnect(drv,

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 All, We are using the following dataset which contains UTF-8 characters and is stored in a MySQL database. When we use RODBC and read the data, the characters are read correctly.But when we read using RJDBC ,the characters are read like ???????????????????????????1 Can you please let me know how we can read the UTF-8 characters as it is done by RODBC. ID code Outlook Temperature Humidity

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

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