turbodbc: [Oracle][ODBC]Invalid SQL data type <-25>

I’m seeing the below error when trying to query one of our Oracle databases

Error: ODBC error
state: HY004
native error code: 0
message: [Oracle][ODBC]Invalid SQL data type <-25>.

Will try to narrow down the culprit when I can find the time to dig into it…

About this issue

Original URL
State: open
Created 6 years ago
Comments: 16 (5 by maintainers)

Most upvoted comments

I’ve experienced this problem as well, and had to use cx_Oracle for certain tables, instead of my preferred (much faster) turbodbc.

mccarthysean on Jan 31, 2018

The decimal data type is both an IEEE standard as well as part of ANSI SQL-92.

Whilst it isn’t well supported by numpy it is supported by Arrow.

The decimal type isn’t useful IMHO for analytic work as it’s several times slower than using floating point numbers as it doesn’t have any support in hardware. Also, none of the standard numerical routines BLAS/LAPACK will work with decimal types. Nevertheless it’s very commonly used for storing financial data so it would be good to have it well supported by turbodbc.

If adding support for more integer types also fixes this issue I’d be very happy with that resolution!

dhirschfeld on Jan 11, 2018