I'm building a custom function for creating a connection to Oracle DB in the following format:
create_connection <- function() {
DBI::dbConnect(
drv = odbc::odbc(),
DSN = "",
Driver = "Oracle blah",
PWD = "my_pwd",
UID = "...",
Port = 1234567,
encoding = "windows-1252",
path = ":abcd:"
)
}
I'm running into some issues when calling this create_connection()
in some circumstances, and I'd like to post a question with a reproducible example. However, I can't provide the real connection parameters to my Oracle DB. Is there a DB that is publicly available for making a reproducible example?
Please note that the example given in dbplyr reference page is not sufficient for demonstrating my problem (i.e., the following isn't good for making an example)
library(dplyr, warn.conflicts = FALSE)
con <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
copy_to(con, mtcars)
Thanks!