Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

dbWriteTable in Oracle does not work with the new version of DBI and ODBC #710

Closed
apalacio9502 opened this issue Dec 23, 2023 · 8 comments
Closed

dbWriteTable in Oracle does not work with the new version of DBI and ODBC #710

apalacio9502 opened this issue Dec 23, 2023 · 8 comments

Comments

@apalacio9502
Copy link

apalacio9502 commented Dec 23, 2023 •
edited
Loading

Hello @hadley,

dbWriteTable in Oracle does not work with the new version of DBI and ODBC. We currently use version 2023-05 of the Oracle professional drivers provided by Posit with the Posit Connect license.

Below I leave the different scenarios where the versions of ODBC and DBI vary, it is important to highlight that in each case the dbWriteTable method is called three times:

  • The table is created for the first time
  • The table is overwritten (overwrite = TRUE, append =FALSE)
  • Information is added (overwrite = FALSE, append =TRUE)

Case 0: DBI 1.1.3 and ODBC 1.3.4 (0 Errors)

# Load libraries
library(DBI)

# Open Database Connection
conn <- dbConnect(
  odbc::odbc(),
  dsn="*****",
  timezone = "America/Bogota", timezone_out = "America/Bogota"
)   

# Write Data to Database
dbWriteTable(
  conn = conn,
  name = SQL("*****.TABLE_TEST"),
  value = mtcars
)

# Overwrite Data to Database
dbWriteTable(
  conn = conn,
  name = SQL("*****.TABLE_TEST"),
  value = mtcars,
  overwrite = TRUE,
  append = FALSE
)

# Append Data to Database
dbWriteTable(
  conn = conn,
  name = SQL("*****.TABLE_TEST"),
  value = mtcars,
  overwrite = FALSE,
  append = TRUE
)

# Close Database Connection
dbDisconnect(conn = conn)

Created on 2023-12-23 with reprex v2.0.2

Session info 
sessioninfo::session_info()
#> ─ Session info ───────────────────────────────────────────────────────────────
#>  setting  value
#>  version  R version 4.3.2 (2023-10-31)
#>  os       Oracle Linux Server 8.7
#>  system   x86_64, linux-gnu
#>  ui       X11
#>  language (EN)
#>  collate  en_US.UTF-8
#>  ctype    en_US.UTF-8
#>  tz       America/Bogota
#>  date     2023-12-23
#>  pandoc   3.1.1 @ /usr/lib/rstudio-server/bin/quarto/bin/tools/ (via rmarkdown)
#> 
#> ─ Packages ───────────────────────────────────────────────────────────────────
#>  package     * version date (UTC) lib source
#>  bit           4.0.5   2022-11-15 [1] CRAN (R 4.3.2)
#>  bit64         4.0.5   2020-08-30 [1] CRAN (R 4.3.2)
#>  blob          1.2.4   2023-03-17 [1] CRAN (R 4.3.2)
#>  cli           3.6.2   2023-12-11 [1] CRAN (R 4.3.2)
#>  DBI         * 1.1.3   2022-06-18 [1] CRAN (R 4.3.2)
#>  digest        0.6.33  2023-07-07 [1] CRAN (R 4.3.2)
#>  evaluate      0.23    2023-11-01 [1] CRAN (R 4.3.2)
#>  fastmap       1.1.1   2023-02-24 [1] CRAN (R 4.3.2)
#>  fs            1.6.3   2023-07-20 [1] CRAN (R 4.3.2)
#>  glue          1.6.2   2022-02-24 [1] CRAN (R 4.3.2)
#>  hms           1.1.3   2023-03-21 [1] CRAN (R 4.3.2)
#>  htmltools     0.5.7   2023-11-03 [1] CRAN (R 4.3.2)
#>  knitr         1.45    2023-10-30 [1] CRAN (R 4.3.2)
#>  lifecycle     1.0.4   2023-11-07 [1] CRAN (R 4.3.2)
#>  magrittr      2.0.3   2022-03-30 [1] CRAN (R 4.3.2)
#>  odbc          1.3.4   2023-01-17 [1] CRAN (R 4.3.2)
#>  pkgconfig     2.0.3   2019-09-22 [1] CRAN (R 4.3.2)
#>  purrr         1.0.2   2023-08-10 [1] CRAN (R 4.3.2)
#>  R.cache       0.16.0  2022-07-21 [1] CRAN (R 4.3.2)
#>  R.methodsS3   1.8.2   2022-06-13 [1] CRAN (R 4.3.2)
#>  R.oo          1.25.0  2022-06-12 [1] CRAN (R 4.3.2)
#>  R.utils       2.12.3  2023-11-18 [1] CRAN (R 4.3.2)
#>  Rcpp          1.0.11  2023-07-06 [1] CRAN (R 4.3.2)
#>  reprex        2.0.2   2022-08-17 [1] CRAN (R 4.3.2)
#>  rlang         1.1.2   2023-11-04 [1] CRAN (R 4.3.2)
#>  rmarkdown     2.25    2023-09-18 [1] CRAN (R 4.3.2)
#>  rstudioapi    0.15.0  2023-07-07 [1] CRAN (R 4.3.2)
#>  sessioninfo   1.2.2   2021-12-06 [1] CRAN (R 4.3.2)
#>  styler        1.10.2  2023-08-29 [1] CRAN (R 4.3.2)
#>  vctrs         0.6.5   2023-12-01 [1] CRAN (R 4.3.2)
#>  withr         2.5.2   2023-10-30 [1] CRAN (R 4.3.2)
#>  xfun          0.41    2023-11-01 [1] CRAN (R 4.3.2)
#>  yaml          2.3.8   2023-12-11 [1] CRAN (R 4.3.2)
#> 
#>  [1] /u01/rstudio-server/pre.data/R
#>  [2] /opt/R/4.3.2/lib/R/library
#> 
#> ──────────────────────────────────────────────────────────────────────────────

Case 1: DBI 1.2.0 and ODBC 1.3.4 (3 Errors)

# Load libraries
library(DBI)

# Open Database Connection
conn <- dbConnect(
  odbc::odbc(),
  dsn="*****",
  timezone = "America/Bogota", timezone_out = "America/Bogota"
)   

# Write Data to Database
dbWriteTable(
  conn = conn,
  name = SQL("*****.TABLE_TEST"),
  value = mtcars
)
#> Error in name@name[["table"]]: subscript out of bounds

# Overwrite Data to Database
dbWriteTable(
  conn = conn,
  name = SQL("*****.TABLE_TEST"),
  value = mtcars,
  overwrite = TRUE,
  append = FALSE
)
#> Error in name@name[["table"]]: subscript out of bounds

# Append Data to Database
dbWriteTable(
  conn = conn,
  name = SQL("*****.TABLE_TEST"),
  value = mtcars,
  overwrite = FALSE,
  append = TRUE
)
#> Error in name@name[["table"]]: subscript out of bounds

# Close Database Connection
dbDisconnect(conn = conn)

Created on 2023-12-23 with reprex v2.0.2

Session info 
sessioninfo::session_info()
#> ─ Session info ───────────────────────────────────────────────────────────────
#>  setting  value
#>  version  R version 4.3.2 (2023-10-31)
#>  os       Oracle Linux Server 8.7
#>  system   x86_64, linux-gnu
#>  ui       X11
#>  language (EN)
#>  collate  en_US.UTF-8
#>  ctype    en_US.UTF-8
#>  tz       America/Bogota
#>  date     2023-12-23
#>  pandoc   3.1.1 @ /usr/lib/rstudio-server/bin/quarto/bin/tools/ (via rmarkdown)
#> 
#> ─ Packages ───────────────────────────────────────────────────────────────────
#>  package     * version date (UTC) lib source
#>  bit           4.0.5   2022-11-15 [1] CRAN (R 4.3.2)
#>  bit64         4.0.5   2020-08-30 [1] CRAN (R 4.3.2)
#>  blob          1.2.4   2023-03-17 [1] CRAN (R 4.3.2)
#>  cli           3.6.2   2023-12-11 [1] CRAN (R 4.3.2)
#>  DBI         * 1.2.0   2023-12-21 [1] CRAN (R 4.3.2)
#>  digest        0.6.33  2023-07-07 [1] CRAN (R 4.3.2)
#>  evaluate      0.23    2023-11-01 [1] CRAN (R 4.3.2)
#>  fastmap       1.1.1   2023-02-24 [1] CRAN (R 4.3.2)
#>  fs            1.6.3   2023-07-20 [1] CRAN (R 4.3.2)
#>  glue          1.6.2   2022-02-24 [1] CRAN (R 4.3.2)
#>  hms           1.1.3   2023-03-21 [1] CRAN (R 4.3.2)
#>  htmltools     0.5.7   2023-11-03 [1] CRAN (R 4.3.2)
#>  knitr         1.45    2023-10-30 [1] CRAN (R 4.3.2)
#>  lifecycle     1.0.4   2023-11-07 [1] CRAN (R 4.3.2)
#>  magrittr      2.0.3   2022-03-30 [1] CRAN (R 4.3.2)
#>  odbc          1.3.4   2023-01-17 [1] CRAN (R 4.3.2)
#>  pkgconfig     2.0.3   2019-09-22 [1] CRAN (R 4.3.2)
#>  purrr         1.0.2   2023-08-10 [1] CRAN (R 4.3.2)
#>  R.cache       0.16.0  2022-07-21 [1] CRAN (R 4.3.2)
#>  R.methodsS3   1.8.2   2022-06-13 [1] CRAN (R 4.3.2)
#>  R.oo          1.25.0  2022-06-12 [1] CRAN (R 4.3.2)
#>  R.utils       2.12.3  2023-11-18 [1] CRAN (R 4.3.2)
#>  Rcpp          1.0.11  2023-07-06 [1] CRAN (R 4.3.2)
#>  reprex        2.0.2   2022-08-17 [1] CRAN (R 4.3.2)
#>  rlang         1.1.2   2023-11-04 [1] CRAN (R 4.3.2)
#>  rmarkdown     2.25    2023-09-18 [1] CRAN (R 4.3.2)
#>  rstudioapi    0.15.0  2023-07-07 [1] CRAN (R 4.3.2)
#>  sessioninfo   1.2.2   2021-12-06 [1] CRAN (R 4.3.2)
#>  styler        1.10.2  2023-08-29 [1] CRAN (R 4.3.2)
#>  vctrs         0.6.5   2023-12-01 [1] CRAN (R 4.3.2)
#>  withr         2.5.2   2023-10-30 [1] CRAN (R 4.3.2)
#>  xfun          0.41    2023-11-01 [1] CRAN (R 4.3.2)
#>  yaml          2.3.8   2023-12-11 [1] CRAN (R 4.3.2)
#> 
#>  [1] /u01/rstudio-server/pre.data/R
#>  [2] /opt/R/4.3.2/lib/R/library
#> 
#> ──────────────────────────────────────────────────────────────────────────────

Case 2: DBI 1.1.3 and ODBC 1.4.1 (1 Message and 2 Errors)

# Load libraries
library(DBI)

# Open Database Connection
conn <- dbConnect(
  odbc::odbc(),
  dsn="*****",
  timezone = "America/Bogota", timezone_out = "America/Bogota"
)   

# Write Data to Database
dbWriteTable(
  conn = conn,
  name = SQL("*****.TABLE_TEST"),
  value = mtcars
)
#> Note: method with signature 'Oracle#character' chosen for function 'odbcConnectionColumns',
#>  target signature 'Oracle#SQL'.
#>  "OdbcConnection#SQL" would also be valid

# Overwrite Data to Database
dbWriteTable(
  conn = conn,
  name = SQL("*****.TABLE_TEST"),
  value = mtcars,
  overwrite = TRUE,
  append = FALSE
)
#> Error in eval(expr, envir, enclos): nanodbc/nanodbc.cpp:1710: 00000
#> [RStudio][OracleOCI] (3000) Oracle Caller Interface: ORA-00955: este nombre ya lo está utilizando otro objeto existente

# Append Data to Database
dbWriteTable(
  conn = conn,
  name = SQL("*****.TABLE_TEST"),
  value = mtcars,
  overwrite = FALSE,
  append = TRUE
)
#> Error in eval(expr, envir, enclos): nanodbc/nanodbc.cpp:1710: 00000
#> [RStudio][OracleOCI] (3000) Oracle Caller Interface: ORA-00955: este nombre ya lo está utilizando otro objeto existente

# Close Database Connection
dbDisconnect(conn = conn)

Created on 2023-12-23 with reprex v2.0.2

Session info 
sessioninfo::session_info()
#> ─ Session info ───────────────────────────────────────────────────────────────
#>  setting  value
#>  version  R version 4.3.2 (2023-10-31)
#>  os       Oracle Linux Server 8.7
#>  system   x86_64, linux-gnu
#>  ui       X11
#>  language (EN)
#>  collate  en_US.UTF-8
#>  ctype    en_US.UTF-8
#>  tz       America/Bogota
#>  date     2023-12-23
#>  pandoc   3.1.1 @ /usr/lib/rstudio-server/bin/quarto/bin/tools/ (via rmarkdown)
#> 
#> ─ Packages ───────────────────────────────────────────────────────────────────
#>  package     * version date (UTC) lib source
#>  bit           4.0.5   2022-11-15 [1] CRAN (R 4.3.2)
#>  bit64         4.0.5   2020-08-30 [1] CRAN (R 4.3.2)
#>  blob          1.2.4   2023-03-17 [1] CRAN (R 4.3.2)
#>  cli           3.6.2   2023-12-11 [1] CRAN (R 4.3.2)
#>  DBI         * 1.1.3   2022-06-18 [1] CRAN (R 4.3.2)
#>  digest        0.6.33  2023-07-07 [1] CRAN (R 4.3.2)
#>  evaluate      0.23    2023-11-01 [1] CRAN (R 4.3.2)
#>  fastmap       1.1.1   2023-02-24 [1] CRAN (R 4.3.2)
#>  fs            1.6.3   2023-07-20 [1] CRAN (R 4.3.2)
#>  glue          1.6.2   2022-02-24 [1] CRAN (R 4.3.2)
#>  hms           1.1.3   2023-03-21 [1] CRAN (R 4.3.2)
#>  htmltools     0.5.7   2023-11-03 [1] CRAN (R 4.3.2)
#>  knitr         1.45    2023-10-30 [1] CRAN (R 4.3.2)
#>  lifecycle     1.0.4   2023-11-07 [1] CRAN (R 4.3.2)
#>  magrittr      2.0.3   2022-03-30 [1] CRAN (R 4.3.2)
#>  odbc          1.4.1   2023-12-21 [1] CRAN (R 4.3.2)
#>  pkgconfig     2.0.3   2019-09-22 [1] CRAN (R 4.3.2)
#>  purrr         1.0.2   2023-08-10 [1] CRAN (R 4.3.2)
#>  R.cache       0.16.0  2022-07-21 [1] CRAN (R 4.3.2)
#>  R.methodsS3   1.8.2   2022-06-13 [1] CRAN (R 4.3.2)
#>  R.oo          1.25.0  2022-06-12 [1] CRAN (R 4.3.2)
#>  R.utils       2.12.3  2023-11-18 [1] CRAN (R 4.3.2)
#>  Rcpp          1.0.11  2023-07-06 [1] CRAN (R 4.3.2)
#>  reprex        2.0.2   2022-08-17 [1] CRAN (R 4.3.2)
#>  rlang         1.1.2   2023-11-04 [1] CRAN (R 4.3.2)
#>  rmarkdown     2.25    2023-09-18 [1] CRAN (R 4.3.2)
#>  rstudioapi    0.15.0  2023-07-07 [1] CRAN (R 4.3.2)
#>  sessioninfo   1.2.2   2021-12-06 [1] CRAN (R 4.3.2)
#>  styler        1.10.2  2023-08-29 [1] CRAN (R 4.3.2)
#>  vctrs         0.6.5   2023-12-01 [1] CRAN (R 4.3.2)
#>  withr         2.5.2   2023-10-30 [1] CRAN (R 4.3.2)
#>  xfun          0.41    2023-11-01 [1] CRAN (R 4.3.2)
#>  yaml          2.3.8   2023-12-11 [1] CRAN (R 4.3.2)
#> 
#> ──────────────────────────────────────────────────────────────────────────────

Case 3: DBI 1.2.0 and ODBC 1.4.1 (3 Errors)

# Load libraries
library(DBI)

# Open Database Connection
conn <- dbConnect(
  odbc::odbc(),
  dsn="*****",
  timezone = "America/Bogota", timezone_out = "America/Bogota"
)   

# Write Data to Database
dbWriteTable(
  conn = conn,
  name = SQL("*****.TABLE_TEST"),
  value = mtcars
)
#> Error in (function (classes, fdef, mtable) : unable to find an inherited method for function 'dbExistsTable' for signature '"Oracle", "NULL"'

# Overwrite Data to Database
dbWriteTable(
  conn = conn,
  name = SQL("*****.TABLE_TEST"),
  value = mtcars,
  overwrite = TRUE,
  append = FALSE
)
#> Error in (function (classes, fdef, mtable) : unable to find an inherited method for function 'dbExistsTable' for signature '"Oracle", "NULL"'

# Append Data to Database
dbWriteTable(
  conn = conn,
  name = SQL("*****.TABLE_TEST"),
  value = mtcars,
  overwrite = FALSE,
  append = TRUE
)
#> Error in (function (classes, fdef, mtable) : unable to find an inherited method for function 'dbExistsTable' for signature '"Oracle", "NULL"'

# Close Database Connection
dbDisconnect(conn = conn)

Created on 2023-12-23 with reprex v2.0.2

Session info 
sessioninfo::session_info()
#> ─ Session info ───────────────────────────────────────────────────────────────
#>  setting  value
#>  version  R version 4.3.2 (2023-10-31)
#>  os       Oracle Linux Server 8.7
#>  system   x86_64, linux-gnu
#>  ui       X11
#>  language (EN)
#>  collate  en_US.UTF-8
#>  ctype    en_US.UTF-8
#>  tz       America/Bogota
#>  date     2023-12-23
#>  pandoc   3.1.1 @ /usr/lib/rstudio-server/bin/quarto/bin/tools/ (via rmarkdown)
#> 
#> ─ Packages ───────────────────────────────────────────────────────────────────
#>  package     * version date (UTC) lib source
#>  bit           4.0.5   2022-11-15 [1] CRAN (R 4.3.2)
#>  bit64         4.0.5   2020-08-30 [1] CRAN (R 4.3.2)
#>  blob          1.2.4   2023-03-17 [1] CRAN (R 4.3.2)
#>  cli           3.6.2   2023-12-11 [1] CRAN (R 4.3.2)
#>  DBI         * 1.2.0   2023-12-21 [1] CRAN (R 4.3.2)
#>  digest        0.6.33  2023-07-07 [1] CRAN (R 4.3.2)
#>  evaluate      0.23    2023-11-01 [1] CRAN (R 4.3.2)
#>  fastmap       1.1.1   2023-02-24 [1] CRAN (R 4.3.2)
#>  fs            1.6.3   2023-07-20 [1] CRAN (R 4.3.2)
#>  glue          1.6.2   2022-02-24 [1] CRAN (R 4.3.2)
#>  hms           1.1.3   2023-03-21 [1] CRAN (R 4.3.2)
#>  htmltools     0.5.7   2023-11-03 [1] CRAN (R 4.3.2)
#>  knitr         1.45    2023-10-30 [1] CRAN (R 4.3.2)
#>  lifecycle     1.0.4   2023-11-07 [1] CRAN (R 4.3.2)
#>  magrittr      2.0.3   2022-03-30 [1] CRAN (R 4.3.2)
#>  odbc          1.4.1   2023-12-21 [1] CRAN (R 4.3.2)
#>  pkgconfig     2.0.3   2019-09-22 [1] CRAN (R 4.3.2)
#>  purrr         1.0.2   2023-08-10 [1] CRAN (R 4.3.2)
#>  R.cache       0.16.0  2022-07-21 [1] CRAN (R 4.3.2)
#>  R.methodsS3   1.8.2   2022-06-13 [1] CRAN (R 4.3.2)
#>  R.oo          1.25.0  2022-06-12 [1] CRAN (R 4.3.2)
#>  R.utils       2.12.3  2023-11-18 [1] CRAN (R 4.3.2)
#>  Rcpp          1.0.11  2023-07-06 [1] CRAN (R 4.3.2)
#>  reprex        2.0.2   2022-08-17 [1] CRAN (R 4.3.2)
#>  rlang         1.1.2   2023-11-04 [1] CRAN (R 4.3.2)
#>  rmarkdown     2.25    2023-09-18 [1] CRAN (R 4.3.2)
#>  rstudioapi    0.15.0  2023-07-07 [1] CRAN (R 4.3.2)
#>  sessioninfo   1.2.2   2021-12-06 [1] CRAN (R 4.3.2)
#>  styler        1.10.2  2023-08-29 [1] CRAN (R 4.3.2)
#>  vctrs         0.6.5   2023-12-01 [1] CRAN (R 4.3.2)
#>  withr         2.5.2   2023-10-30 [1] CRAN (R 4.3.2)
#>  xfun          0.41    2023-11-01 [1] CRAN (R 4.3.2)
#>  yaml          2.3.8   2023-12-11 [1] CRAN (R 4.3.2)
#> 
#>  [1] /u01/rstudio-server/pre.data/R
#>  [2] /opt/R/4.3.2/lib/R/library
#> 
#> ──────────────────────────────────────────────────────────────────────────────

I hope these reprex are helpful to correct the error.

Regards
@apalacio9502 apalacio9502 mentioned this issue Dec 23, 2023
Closed
@detule
Copy link
Collaborator

detule commented Dec 23, 2023 •
edited
Loading

Hi @apalacio9502

Thanks for your report.
The DBI issues aside ( will look into those as well ), the issue seems to be related to using tables with underscores.

Can you confirm that with DBI 1.1.3 + odbc 1.4.1, and a table (and schema) name that does not have underscores, you don't see the issue at hand.

The warning message is OK - something we are aware of and plan on addressing in an upcoming release.

@detule
Copy link
Collaborator

detule commented Dec 23, 2023

Also, had a chance to chase down the DBI 1.1.3 vs 1.2.0 issue - updated the issue you raised in package:DBI.

Thanks again for your detailed report.

@apalacio9502
Copy link
Author

apalacio9502 commented Dec 24, 2023 •
edited
Loading

Hi @apalacio9502

Thanks for your report. The DBI issues aside ( will look into those as well ), the issue seems to be related to using tables with underscores.

Can you confirm that with DBI 1.1.3 + odbc 1.4.1, and a table (and schema) name that does not have underscores, you don't see the issue at hand.

The warning message is OK - something we are aware of and plan on addressing in an upcoming release.

Hello @detule,

Thanks for the prompt response, I performed the suggested test and I see that it works correctly if the table name does not have an underscore.

However, for our case all our databases have undersocres in the table names. I think it is common for table names to have underscores.

# Load libraries
library(DBI)

# Open Database Connection
conn <- dbConnect(
  odbc::odbc(),
  dsn="*****",
  timezone = "America/Bogota", timezone_out = "America/Bogota"
)   

# Write Data to Database
dbWriteTable(
  conn = conn,
  name = SQL("*****.TABLETEST"),
  value = mtcars
)
#> Note: method with signature 'Oracle#character' chosen for function 'odbcConnectionColumns',
#>  target signature 'Oracle#SQL'.
#>  "OdbcConnection#SQL" would also be valid

# Overwrite Data to Database
dbWriteTable(
  conn = conn,
  name = SQL("*****.TABLETEST"),
  value = mtcars,
  overwrite = TRUE,
  append = FALSE
)

# Append Data to Database
dbWriteTable(
  conn = conn,
  name = SQL("*****.TABLETEST"),
  value = mtcars,
  overwrite = FALSE,
  append = TRUE
)

# Close Database Connection
dbDisconnect(conn = conn)

Created on 2023-12-23 with reprex v2.0.2

Session info 
sessioninfo::session_info()
#> ─ Session info ───────────────────────────────────────────────────────────────
#>  setting  value
#>  version  R version 4.3.2 (2023-10-31)
#>  os       Oracle Linux Server 8.7
#>  system   x86_64, linux-gnu
#>  ui       X11
#>  language (EN)
#>  collate  en_US.UTF-8
#>  ctype    en_US.UTF-8
#>  tz       America/Bogota
#>  date     2023-12-23
#>  pandoc   3.1.1 @ /usr/lib/rstudio-server/bin/quarto/bin/tools/ (via rmarkdown)
#> 
#> ─ Packages ───────────────────────────────────────────────────────────────────
#>  package     * version date (UTC) lib source
#>  bit           4.0.5   2022-11-15 [1] CRAN (R 4.3.2)
#>  bit64         4.0.5   2020-08-30 [1] CRAN (R 4.3.2)
#>  blob          1.2.4   2023-03-17 [1] CRAN (R 4.3.2)
#>  cli           3.6.2   2023-12-11 [1] CRAN (R 4.3.2)
#>  DBI         * 1.1.3   2022-06-18 [1] CRAN (R 4.3.2)
#>  digest        0.6.33  2023-07-07 [1] CRAN (R 4.3.2)
#>  evaluate      0.23    2023-11-01 [1] CRAN (R 4.3.2)
#>  fastmap       1.1.1   2023-02-24 [1] CRAN (R 4.3.2)
#>  fs            1.6.3   2023-07-20 [1] CRAN (R 4.3.2)
#>  glue          1.6.2   2022-02-24 [1] CRAN (R 4.3.2)
#>  hms           1.1.3   2023-03-21 [1] CRAN (R 4.3.2)
#>  htmltools     0.5.7   2023-11-03 [1] CRAN (R 4.3.2)
#>  knitr         1.45    2023-10-30 [1] CRAN (R 4.3.2)
#>  lifecycle     1.0.4   2023-11-07 [1] CRAN (R 4.3.2)
#>  magrittr      2.0.3   2022-03-30 [1] CRAN (R 4.3.2)
#>  odbc          1.4.1   2023-12-21 [1] CRAN (R 4.3.2)
#>  pkgconfig     2.0.3   2019-09-22 [1] CRAN (R 4.3.2)
#>  purrr         1.0.2   2023-08-10 [1] CRAN (R 4.3.2)
#>  R.cache       0.16.0  2022-07-21 [1] CRAN (R 4.3.2)
#>  R.methodsS3   1.8.2   2022-06-13 [1] CRAN (R 4.3.2)
#>  R.oo          1.25.0  2022-06-12 [1] CRAN (R 4.3.2)
#>  R.utils       2.12.3  2023-11-18 [1] CRAN (R 4.3.2)
#>  Rcpp          1.0.11  2023-07-06 [1] CRAN (R 4.3.2)
#>  reprex        2.0.2   2022-08-17 [1] CRAN (R 4.3.2)
#>  rlang         1.1.2   2023-11-04 [1] CRAN (R 4.3.2)
#>  rmarkdown     2.25    2023-09-18 [1] CRAN (R 4.3.2)
#>  rstudioapi    0.15.0  2023-07-07 [1] CRAN (R 4.3.2)
#>  sessioninfo   1.2.2   2021-12-06 [1] CRAN (R 4.3.2)
#>  styler        1.10.2  2023-08-29 [1] CRAN (R 4.3.2)
#>  vctrs         0.6.5   2023-12-01 [1] CRAN (R 4.3.2)
#>  withr         2.5.2   2023-10-30 [1] CRAN (R 4.3.2)
#>  xfun          0.41    2023-11-01 [1] CRAN (R 4.3.2)
#>  yaml          2.3.8   2023-12-11 [1] CRAN (R 4.3.2)
#> 
#>  [1] /u01/rstudio-server/pre.data/R
#>  [2] /opt/R/4.3.2/lib/R/library
#> 
#> ──────────────────────────────────────────────────────────────────────────────

@apalacio9502
Copy link
Author

Also, had a chance to chase down the DBI 1.1.3 vs 1.2.0 issue - updated the issue you raised in package:DBI.

Thanks again for your detailed report.

Thank you @detule,

Is there any branch that we can test to support them with tests?

@apalacio9502
Copy link
Author

@detule, @hadley

We would like to find some way to support you with ODBC and DBI testing with Oracle, because for example the last 3 versions of ODBC have errors with Oracle, and we clearly understand that this has happened because the community is testing after it comes out a new version and not before a new version is released.

Regards,

@krlmlr krlmlr mentioned this issue Dec 24, 2023
Closed
6 tasks
@detule
Copy link
Collaborator

detule commented Dec 26, 2023

Thanks @apalacio9502 / appreciate the sentiment, and the offer to help test.

We too are interested in making sure we don't disrupt the workflow for Oracle users. In particular, for future releases we have a bullet item to add Oracle to the CI/CD infrastructure. As part of that process, each time we make a change to the package, something like five thousand unit tests are deployed - that should help with making our process more robust against Oracle.

Thanks again for your patience.

@detule detule mentioned this issue Jan 4, 2024
Merged
@ibecav ibecav mentioned this issue Jan 9, 2024
Closed
@hadley
Copy link
Member

hadley commented Jan 18, 2024

Fixed by #712 and #721.

@hadley hadley closed this as completed Jan 18, 2024
@apalacio9502
Copy link
Author

Hi @hadley @detule,

Apologies for the delay. I can now confirm that the problem has been successfully resolved. I conducted a test using ODBC (dev) + DBI (1.1.3) or ODBC (dev) + DBI (1.2.1).

I believe this matter can be marked as complete with reference to the Oracle-related discussion on GitHub (r-dbi/DBI#446).

Regards,

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@hadley @detule @apalacio9502