similar to: ROracle Win2K

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

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

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:

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

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

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

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

Thank you to David James for the solution to this one! David James wrote: > The workaround in the README.Oracle9 files is intended for the symbol > sqlda (I think), but the sqlctx symbol apparently is defined in > -lclntsh. > So, could you try the following? R CMD INSTALL --configure-args='--enable-oracle32 --enable-extralibs="-lsqlplus -lclntsh"'

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, I found the same question in the mailing list already a few months ago - but there was no answer to it - so I'll try it again Could somebody help me to solve this following problem? I just begin to learn how to connect my Oracle database with R. > library(DBI) > library(ROracle) Warning message: DLL attempted to change FPU control word from 8001f to 9001f >

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]

Full_Name: JinNyong Huh Version: 2.6.1 OS: Linux(SUSE-9.0) Submission from: (NULL) (220.75.209.235) ROracle Packages is not to be installed in my Linux. The enviroments are as follows: * O/S Profile [ export ORACLE_BASE=/opt/oracle export ORACLE_SID=DEMO10G export ORACLE_HOME=$ORACLE_BASE/product/10g export ORACLE_DOC=$ORACLE_HOME/doc export ORACLE_TERM=vt220 export TERM=vt100 export