32-bit version about shiny

[cboettig]

@stvrd Have you considered using the odbc package instead? https://cran.r-project.org/web/packages/odbc/index.html

I believe Oracle DB works fine with 64 bit systems on Linux with the odbc drivers already included in the image...

[stvrd]

I would prefer working with the odbc package, but I get the error message:
[Oracle][ODBC]Invalid SQL data type <-25> (see here).

The only workaround seems to be using RODBC package, which in turn only runs on 32-bit R. Is there any chance to make this work with rocker/shiny-verse ?

[eddelbuettel]

You can write SQL queries that case to a different type, that may avoid "type 25". Otherwise maybe report and error with that package?

[stvrd]

This sounds promising, could you elaborate what you mean by 'case to a different type' ?

[eddelbuettel]

First google hit for 'sql select cast': https://www.1keydata.com/sql/sql-cast.html

[stvrd]

Sorry using Ecosia not google. The 'type 25' issue is already reported, without solution so far (here). Casting to a different data type unfortunately does not work because the error occurs before any data is transferred, so I am not able to work with any column at all.

Back to the issue subject, is there any chance to use R 32-bit with rocker/shiny-verse ?

[eddelbuettel]

I am locking this issue. Your lack of familiarity with SQL and unhappyness with the package you are using are both orthogonal to our Rocker Project.