Search Archives
Search tips
from:Name
Search by author name, e.g. from:Duncan Murdoch
"exact phrase"
Match an exact phrase
word1 word2
Match messages containing both words
Date range
Use the date pickers to filter results to a time period
Use the list dropdown to narrow results to a specific mailing list. Combine from: with other terms to filter by author and content.
I like it. dbExecuteQuery() matches well with already existing dbGetQuery() and dbSendQuery(). All three are essentially doing the same operation (submitting a Query) but have different return types. Denis -----Original Message----- From: Hadley Wickham [mailto:hadley at rstudio.com] Sent...
Sai, You are probably missing ORACLE_HOME and OREACLE_SID in the RStudio environment. Try creating ~/.Renviron and put the following in it: ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 ORACLE_SID=<your sid (the default...
David, You are missing a call to dbClearResult right after dbSendQuery. This call will release the cursor. However, a better way to do this is to use bulk binds. I had an example in my previous post to this list...
In ROracle we standardized on the second approach, namely always return TRUE, otherwise throw an error. Also since UPDATE is not the only operation that does not return any results (although it might with a RETURNING clause) would a more...
David, Have you considered using ROracle instead? It is also DBI based. ROracle uses native interfaces (OCI) so it should be much faster (although I have not run any comparisons). It is also actively maintained by Oracle so if you...
A new version of ROracle 1.1-7 was uploaded to CRAN earlier today. We added a fix that will allow you to read DATE and TIMSTAMP columns with different versions of timezone files between your client machine and Oracle...
Don, 1) dbListTables now takes two additional arguments that control the display of tables/views in other schemas (assuming you have select access on these). Here is the description from the man page: dbListTables(conn, schema = NULL, all = FALSE, full...
David, ? Thank you for reporting this. I'll make sure to update the INSTALL file that comes with ROracle package to include this information. Unfortunately, this information is not easily available when you download Instant Client. The only place I...
James, I have never tried RPostgreSQL before but in ROracle which is also a DBI based interface you can do something like this: library(ROracle) con <- dbConnect(Oracle(), "scott", "tiger") dbGetQuery(con, "create table foo as select * from emp") dat...
Can't find what you're looking for? Try searching with Google .