similar to: ROracle 0.5-0 package update

Hi all, I've been playing with ROracle (0.5-9) for a few days and I can't wrap my mind around this one. Here's a sample of my R (2.4.0) session. my.df<-data.frame(prd_id=c(123,456),vol_factor=c(.123,.456)) > my.df prd_id vol_factor 1 123 0.123 2 456 0.456 > library(ROracle) Loading required package: DBI >

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

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

Hello everybody, I found that queries (send by "dbExecStatement" ) with more than 4000 characters length produces an error in ROracle (ver 0.3-3). Maybe there is a limitation of 4kB.... Is this a bug? If yes, is this problem solved in the latest version of ROracle (ver 0.5-0)? My system information: platform sparc-sun-solaris2.8 arch sparc os solaris2.8

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:

Oracle is finally up and running on RH 7.3 now. I will try to summarize the pitfalls to avoid here for future reference. 1> Make sure you have the Pro C/C++ drivers in Oracle client installed. This can be verified by looking for the existence of the proc directory in $ORACLE_HOME. Existence of proc means it worked 2> Put the following in the .bashrc script in root export

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

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, I am trying to install the ROracle package in a Linux-64 machine. I downloaded from Oracle's site their Instant Client bundle but it seems that ROracle needs some stuff not included in that kit in order to compile (in particuar, the 'proc' executable). I did not find any other linux client suite in Oracle's site, (our db runs on a Solaris server, so I can not use the

Hi there! Is ROracle available for Windows, please? I found a download site, but it's really for UNIX/Linux. Here is a "thought question", please: Why do the vector elements start at location 1 rather than zero, as C does? Thanks in advance! R Version 1.9.1 Windows Sincerely, Laura Holt mailto: lauraholt_983 at hotmail.com

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

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

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:

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]

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

Hi guys: When I use the ROracle package, I found the function 'dbWriteTable' can't work. The data frame can't be written to 10g Oracle Data Base. Here is what happened to me. >library(DBI) >library(ROracle) >drv <- Oracle() >con <- dbConnect(drv , 'uid','pw','db') >mm <- data.frame(CO2) >

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

I want to use tryCatch, but tryCatch seems to obscure important things I need for debugging. For example, say I am working with an SQLite database, and have written this function: debugThisFunction <- function(dbfile) { require(RSQLite) drv <- SQLite() conn <- dbConnect(drv, dbfile) tryCatch({ dbBeginTransaction(conn) tryCatch({ for (i in 1:10) {

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