I'm having some problems with Oracle whatever angle I choose. I suspect some of those are not Oracle specific.
The use case is to copy the content of a dm to a specific schema.
1. using the schema arg
dm::copy_dm_to(
connect_to_db(),
dm,
schema = "STORE_VT",
temporary = FALSE
)
#> Error in `abort_no_schemas_supported()`:
#> ! Currently schemas are not supported for a connection of class `Oracle`.
#> Backtrace:
#> ?
#> 1. +-dm::copy_dm_to(connect_to_db(), dm, schema = "STORE_VT", temporary = FALSE)
#> 2. +-dm:::repair_table_names_for_db(...)
#> 3. +-dm:::abort_no_schemas_supported(con = con)
#> 4. +-rlang::abort(error_txt_no_schemas_supported(dbms, con), class = dm_error_full("no_schemas_supported"))
2. table_names as a named character vector
table_names <- setNames(sprintf("STORE_VT.%s", names(dm)), names(dm))
dm::copy_dm_to(
connect_to_db(),
dm,
table_names = table_names,
temporary = FALSE
)
#> downloading data [==========================================================] 100% in 1s
#> Error in `pmap()`:
#> ℹ In index: 1.
#> Caused by error in `result_insert_dataframe()`:
#> ! nanodbc/nanodbc.cpp:1752: 00000: [RStudio][Support] (40465) String data truncated while performing conversion.
#> Run `rlang::last_trace()` to see where the error occurred.
3. Using the documented formula :
I would expect it to be the same as above but this is different.
This creates the tables but doesn't populate them. They're a bit hard to remove properly too, maybe the code should have a safe cleanup on exit if no success ?
It says a vector in the doc, but these are not atomic so I think we might say list.
A first try doesn't work, but after inspection it's because the function is applied on the names vector as a whole, not individual elements, something I don't find intuitive and not very clearly documented:
I'm having some problems with Oracle whatever angle I choose. I suspect some of those are not Oracle specific.
The use case is to copy the content of a dm to a specific schema.
1. using the
schema
arg2.
table_names
as a named character vector3. Using the documented formula :
I would expect it to be the same as above but this is different. This creates the tables but doesn't populate them. They're a bit hard to remove properly too, maybe the code should have a safe cleanup on exit if no success ?
4. a vector of DBI::Id objects.
It says a vector in the doc, but these are not atomic so I think we might say list.
A first try doesn't work, but after inspection it's because the function is applied on the names vector as a whole, not individual elements, something I don't find intuitive and not very clearly documented:
A second try gives a different error :