Displaying 7 results from an estimated 7 matches for "sqlca".
2004 Nov 23
0
ROracle: fetch return zero rows or empty dataset (a workaround!)
...mp; 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 "root"
b) cd /usr/include
c) grep sqlerrml sqlca.h
NOTE: If you see something like below, then bingo! This is the
work-around for you!!
int sqlerrml;
Part 2 - Re-install ROracle properly
a) log in as "root"
b) cd /usr/include
c) mv sqlca.h sqlca.h.xxx
NOTE: This is just to rename the file temporarily
d) Follow all...
2003 Nov 24
1
ROracle issue with shared library and RMySQL
...le library and receive the
following message:
> library(ROracle)
Error in dyn.load(x, as.logical(local), as.logical(now)) :
unable to load shared library
"/usr/local/lib/R/library/ROracle/libs/ROracle.so":
/usr/local/lib/R/library/ROracle/libs/ROracle.so: undefined symbol: sqlca
Error in library(ROracle) : .First.lib failed
My configuration:
Gentoo 1.4 - kernel 2.4.20
Oracle 9.2.0.4 (upgraded 9.2.0.2)
I compiled ROracle with the necessary Oracle libraries in the path. My
LD_LIBRARY_PATH is set to:
/u01/app/oracle/product/9.2.0/lib:/u01/app/oracle/product/9.2.0/precomp...
2004 Jul 12
1
ROracle package error
...e)" I got the following error message:
> library(ROracle)
Error in dyn.load(x, as.logical(local), as.logical(now)) :
unable to load shared library
/home/bonkrad/bin/R/lib/R/library/ROracle/libs/ROracle.so":
/home/bonkrad/bin/R/lib/R/library/ROracle/libs/ROracle.so: undefined
symbol: sqlca
Error in library(ROracle) : .First.lib failed
What is wrong? Is an error on ROracle side or on R side?
Thanks in advance,
Rado
--
Radoslav Bonk
European Commission - DG Joint Research Centre (JRC)
Institute for Environment and Sustainability (IES)
LM Unit - Natural Hazards
Weather Driven Nat...
2003 May 14
1
ROracle problem with Oracle9i on Red Hat 8.0
...>> library(ROracle)
>Error in dyn.load(x, as.logical(local), as.logical(now)) :
> unable to load shared library
"/home/michael/software/R/R-1.7.0/library/ROracle/libs/ROracle.so":
> /home/michael/software/R/R-1.7.0/library/ROracle/libs/ROracle.so:
undefined symbol: sqlca
>Error in library(ROracle) : .First.lib failed
The 2 solutions mentioned in ROracle/inst/INSTALL don't seem to help (1:
define $LD_LIBRARY_PATH, 2: compile statically).
Is there any solution to this? I would greatly appreciate any help!!
Best wishes,
Michael Seewald
---
Michael Seewald,...
2005 Aug 25
5
ROracle and select query empty
Hi,
I just installed ROracle and RDBI. The connection to the database seems
to work also. My problem is when I am selection rows that really exist
in the database, it is returning nothing. Where should I look to see
what could be my problem?
Thank you very much,
Mathieu
> drv <- dbDriver("Oracle")
> summary(drv, verbose=TRUE)
<OraDriver:(6721)>
Driver name:
2009 Feb 26
2
When ODBC native support in wine?
Hello, first , I would like to thank you for your great work with wine.
When will be possible I fine implementation of ODBC support in wine? the actual with MDAC25 /27/28 are not very fine and a lot of people have a lot of problem .... where are a very high application number that need this feature for run proporty.
Thanks a lot
2008 May 23
20
Rails validation is inefficient
Hi,
I have a User model, with a validates_uniqueness_of :login
The generated SQL for the validation is:
SELECT * FROM `users` WHERE (LOWER(users.login) = ''fernando'' AND
users.id <> 10001) LIMIT 1;
and it takes 0.13s to happen (my table has 10.000 rows)
When I use the EXPLAIN instruction on it, it shows that it will use the
primary_key as index, but this is not