Oracle support

[detule]

Hi @krlmlr

I was wondering if you have tested Oracle connections against DB versions 21 or lower with DBItest? One of the issues I came across is related to SQL syntax. For example, trying to execute trivial_query():

> dbGetQuery(conn, "SELECT 1.5 as a")
Error: nanodbc/nanodbc.cpp:1710: 00000
[Oracle][ODBC][Ora]ORA-00923: FROM keyword not found where expected

> dbGetQuery(conn, "SELECT 1.5 as a FROM DUAL")
    A
1 1.5
> dbGetInfo(conn)
$dbname
[1] ""
$dbms.name
[1] "Oracle"
$db.version
[1] "21.00.0000"

...

$odbc.version
[1] "03.52"
$driver.version
[1] "21.12.0000"
$odbcdriver.version
[1] "03.52"

Thanks

[krlmlr]

Thanks, no, haven't. Does this work out of the box in Oracle 22 or higher? What's the EOL for Oracle 21?

[detule]

Haven't tried Oracle 23 / though in some documentation I have read "FROM DUAL" may not be needed there. Having said that and if I am interpreting the schedule here correctly, it seems Oracle 23 is a very recent release with broader distribution still outstanding / slated for 1H24.

Oracle 19 ( previous LT version ) is supported through 2027. If given the option, I think I would use this version as the test bed.

[krlmlr]

There are Docker images for Oracle Express 21 and 18. Would they work too?

Upstream: r-dbi/docker#16.