Displaying 20 results from an estimated 1000 matches similar to: "problem with ROracle - Internal heap ERROR 17177"
2004 Jul 14
3
ROracle - fetch gives empty dataframe
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:
2009 Feb 09
0
ROracle - ORA-02005: implicit (-1) length not valid for this bind or define datatype
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:
2003 May 14
1
ROracle problem with Oracle9i on Red Hat 8.0
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
2004 Jul 14
0
ROracle - fetch gives...(corrected SQL code)
Sorry for posting the second time, I corrected the SQL code:
PROBLEM: after executing simple statement, from within R, "fetch"
function gives me the empty dataframe:
### CONNECTION, and SQL QUERY EXECUTION
> ora <- dbDriver("Oracle")
> con <- dbConnect(ora, "rado/only2admin"
> dbListTables(con)
character(0)
> rs <- dbSendQuery(con,
2005 Sep 08
1
ROracle install problem
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
2005 Nov 03
1
Problem installing ROracle package under R
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:
2004 Jul 12
1
ROracle package error
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
2006 Sep 20
1
[ROracle] error loading (undefined symbol: sqlclu)
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
2004 Jan 20
1
Roracle pre-compile error?
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]
2005 Jan 20
1
ROracle error
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
2003 Nov 24
1
ROracle issue with shared library and RMySQL
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
2005 Aug 23
1
ROracle installation problem
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
2012 Mar 06
1
ROracle package
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
2004 Nov 23
0
ROracle: fetch return zero rows or empty dataset (a workaround!)
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
2004 May 12
0
RE: ROracle package error - Solution
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"'
2002 Aug 23
1
R/SJava/ROracle installation problem
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
2008 Jan 29
1
"ROracle" Packages is not to be installed (PR#10652)
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
2011 Jan 05
1
What are the necessary Oracle software to install and run ROracle ?
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
2004 May 24
1
ROracle on RHEL 3 x86_64
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
2008 Mar 18
1
ROracle installation problem
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