Stack Overflow
Stack Overflow

Questions tagged [roracle]

Oracle database interface (DBI) driver for R. This is a DBI-compliant Oracle driver based on the OCI. It is available through CRAN.

Oracle database interface (DBI) driver for R. This is a DBI-compliant Oracle driver based on the OCI. It is available through CRAN.

Source

119 questions
16
votes
3 answers

ROracle package installation failure

I'm aware of the other questions about this issue, but they don't have much in common with my system setup or the installation error I'm getting, so: I am using Windows 7, 64 bit I have installed the 64 bit Oracle Instant Client 18.3.0.0.0 along…
obrl_soil
  • 1,104
  • 12
  • 24
14
votes
4 answers

collect only if query returns less than n_max rows

Occasionally when connecting to my Oracle database through ROracle and dbplyr I will run a dplyr::collect operation that fetches more data than expected and than R can handle. This can make R crash and is often a sign I should have filtered or…
moodymudskipper
  • 46,417
  • 11
  • 121
  • 167
9
votes
2 answers

Install ROracle in Mac

I'm on Mac OS Sierra. I have tried doing - Installation of RODBC/ROracle packages on OS X Mavericks but it didn't help. This is what I did: Downloaded from http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html - Basic, Sql plus,…
dang
  • 2,342
  • 5
  • 44
  • 91
9
votes
2 answers

How to install ROracle package?

I am trying to install ROracle package using install.packages("ROracle") but every time i am getting this message "Package which is only available in source form, and may need compilation of C/C++/Fortran: ‘ROracle’" These will not be installed I…
user6559913
  • 483
  • 4
  • 7
  • 15
9
votes
1 answer

Using ROracle dbWriteTable to write POSIXct back to Oracle DB

In Oracle DB: DESCRIBE ORACLE_DB_TABLE; |---------------------------------------| | Column Name | Data Type | |---------------------------------------| | TRANSACTION_TIME | DATE | | TRANSACTION_ID | VARCHAR2 (20 Byte)…
chengcj
  • 888
  • 2
  • 8
  • 22
8
votes
2 answers

ROracle not working in R studio

I'm trying to install ROracle package on a unix box. The package gets installed properly. But library(ROracle) does not work fine with the error library(ROracle) Error in dyn.load(file, DLLpath = DLLpath, ...) : unable to load shared object…
user40465
  • 421
  • 2
  • 8
  • 15
7
votes
1 answer

Executing a stored oracle procedure in R using ROracle

I'm having trouble executing/calling an Oracle procedure in R via ROracle. I've tried many different ways of calling the procedure and I keep getting the same errors. I've had no problem doing SELECT queries but calling a procedure is proving…
Ankhnesmerira
  • 1,386
  • 15
  • 29
7
votes
2 answers

rstudioapi askForPassword without masking for username entry

Is there a way to disable the masking in the rstudioapi::askForPassword pop up window so a user can enter their username? I am building a function I can share with my team for connecting to our Oracle DB instance using the ROracle pacakge Current…
blakiseskream
  • 338
  • 4
  • 9
5
votes
1 answer

Installing ROracle

I have downloaded the compiled ROracle package from the Oracle website. I have set my working directory with setwd(). Then I tried to install the package as follows: install.packages("ROracle-1.3.2.zip", repos=NULL) It failed and I got the…
power
  • 1,680
  • 3
  • 18
  • 30
5
votes
2 answers

ROracle installation: Unable to load shared object error

I need to connect R to an Oracle database Followed the instructions on https://cran.r-project.org/web/packages/ROracle/INSTALL, exactly, step by step Getting the following error: library('ROracle') Error in inDL(x, as.logical(local),…
Dan
  • 1,711
  • 2
  • 24
  • 39
5
votes
1 answer

How to specify encoding in rOracle

I've got some troubles with R's package "rOracle" reading cyrillic data from db. I changed my nls_lang option of oracle to AMERICAN_AMERICA.CL8MSWIN1251 so that sqlQuery in rODBC package works fine with option DBMSencoding = "CP1251", but i don't…
Powerfool
  • 299
  • 2
  • 3
  • 9
5
votes
1 answer

ROracle - dbWriteTable, date columns

How can I write data frame with date columns to Oracle database using dbWriteTable? I am trying: df <-read.table(header = TRUE, sep = ',', stringsAsFactors =…
Tomas Greif
  • 21,685
  • 23
  • 106
  • 155
4
votes
1 answer

ROracle connect and pull utf8 characters

I am connecting to an Oracle database from R using ROracle. The problem is for every special utf-8 character it returns a question mark. Some Chinese values returns a solid string of question marks. I believe this is relevant because I haven't…
farmkid
  • 420
  • 2
  • 11
3
votes
2 answers

ROracle on R Version 4.0.0

When trying to use ROracle I get the following error message > library("ROracle") Error: package or namespace load failed for ‘ROracle’: package ‘ROracle’ was installed before R 4.0.0: please re-install it I've installed/downloaded DBI, RTools,…
user2496177
  • 33
  • 1
  • 4
3
votes
2 answers

ROracle dbGetQuery bind parameters by name

I am trying to process a large number of queries with parameters in R using ROracle. I know which parameters appear in each query, but I don't know in which order they appear. I am therefore looking for a way to submit the parameters by name in each…
guzbrush
  • 123
  • 11
1
2 3 4 5 6 7 8