similar to: ROracle and select query empty

I am the maintainer of its, but not it's original author. One of the main strengths of its is that it uses POSIXct dates. Zoo has the flexibility of using almost any date format, but I don't know if the other date formats can store hour, min, sec data. You might want to do a little exploring with each before you commit. I'll be happy to give you a hand if you decide to work with

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:

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

Hi, Hopefully a quick example will illustrate what I''m trying to do. <table> <tr> <td>test</td> <td>test</td> </tr> <tr> <td>row 2</td> <td>row 2</td> </tr> <tr> <td>row 3</td> <td>row 3</td> </tr> </table> Using AJAX, I''d

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 curently have a big problem. One request (listed above) using context take up to 1000 more time than the on RAW or ext2 database. I have ran this request on a single IA32 machine with Redhat and dbf on ext2. The average reponse time is less than a sec. The same request on RAC 4 nodes cluster on RAW take the same average time. On ext2 idem. But on OCFS it took up to 15 sec randomly

Hi all, I curently have a big problem. One request (listed above) using context take up to 1000 more time than the on RAW or ext2 database. I have ran this request on a single IA32 machine with Redhat and dbf on ext2. The average reponse time is less than a sec. The same request on RAC 4 nodes cluster on RAW take the same average time. On ext2 idem. But on OCFS it took up to 15 sec randomly

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:

I rememeber seeing an article about how to cope with legacy databases where the primary key is defined as VARCHAR2. I only want read-access to the data. Does anyone have a link to such an article? Or can give advice? -- Posted via http://www.ruby-forum.com/.

I am having a problem getting Redmine to run with Oracle (11.2) backend. I get this error (below) because Oracle table names are limited to 30 characters. Does anyone around here know of a fix or workaround? I''m wondering if I can simple change the table name, or if that will break the application. When doing a db migrate to an Oracle db this creates the error below. I''m so

If I want to call A/B, can I call a corresponding controller action for it? Like with app/views/A.rhtml, I can it will call the method A in the controller file. But with A/B.rhtml, I cant do def A/B. -- Posted via http://www.ruby-forum.com/.

Hi I run Ruby on Rails on Oracle XE. I have a simple table: create table customer(id number primary key, name varchar2(100)); And ruby script\generate model Customer ruby script\generate controller Customer http://localhost:3000/customer/ - show a fine list, but when I click show/edit/destroy, I get an ORA-01722: OCIError: ORA-01722: invalid number: select * from (select raw_sql_.*,

I''m just looking into how to connect to Oracle using Rails. I''ve got everything connecting and working as it should. I have a Users table in Oracle: create_table "users", :force => true do |t| t.column "username", :string t.column "created_on", :datetime t.column "email", :string t.column "note", :text

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,

Has anyone encountered this error or know how to correct it? I couldn''t find any Rails-specific info about this on google. Here are the circumstances: /usr/local/bin/ruby --version ruby 1.8.4 (2005-12-24) [i686-linux] /usr/local/bin/rails --version Rails 1.1.6 ## Create mcd app rails mcd -d oracle cd mcd ## Create oracle tablespace & user sqlplus ''/ as

If the portion of the file that you want to read is "rectangular" (same number of fields in all lines and same type of data in each column), you can use either read.table() or scan() and supply the skip= argument to skip over the headers you don't want to read in. HTH, Andy > From: Mathieu Drapeau [mailto:mathieu.drapeau at bioneq.qc.ca] > > Hi, > I would like to know

Hi guys: When I use the ROracle package, I found the function 'dbWriteTable' can't work. The data frame can't be written to 10g Oracle Data Base. Here is what happened to me. >library(DBI) >library(ROracle) >drv <- Oracle() >con <- dbConnect(drv , 'uid','pw','db') >mm <- data.frame(CO2) >

Dear all, I using R version 2.9.0 on Windows XP and want to insert data from a data frame in R into a oracle database via sqlUpdate with the package RODBC. My example is the following: TEST0<-data.frame(NR=c(1,2,600),NAME=c("JK","TR","AR"), DATUM=c("2009-01-01","2010-01-02","2010-06-09")) If I create the table in the database with

We are using MFC/R2 driver successfully in at least three places in Brazil. I have problem with an Asterisk integrated with MFC/R2 with a Siemens Hicom 300. I can get a good audio quality with Grandstream, Polycom, and X-Lite softfones, but SIPURAS and Linksys get a garbled audio, something like a "Darth Vader" voice. We have tried everything in Sipura. The SIPURA 2000 and the Linksys