similar to: ROracle - ORA-02005: implicit (-1) length not valid for this bind or define datatype

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

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

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

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

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

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

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