search for: sqlca

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