Created attachment 148384 [details]
Screen captures of error and LibO "About"
I had been using for a long time a connection to Oracle Database data through Base using the Oracle ODBC Driver and this was perfectly working until I updated to LibreOffice 6.2 (Orignally 6.2.1 and now 6.2.2 but does not change result).
I tried to return to LibreOffice 6.1.4 (before installing 6.2, I was running 6.1.2) but, unfortunately any call to display a table, a view or a query ends up with message [ODBC][ORACLE] Optional Feature not implemented.
Error displayed is HYC00.
I tried to reset my UserProfile but no improvement.
I underline that the ODBC driver is fully operational when used from other Windows apllications like MS Excel or MS Access.
I tried to re-create a new Oracle ODBC linkage and connect through it but same message appear. Curiously, when testing connection from my Base File properties menu, test is OK.
Created attachment 148386 [details]
Screen captures of Oracle ODBC Driver parameters
I forgot to highlight that, for compatibility reasons with our ERP system, Oracle Driver is a 32-bit version and i always install LibreOffice in 32-bit version as the 64-bit does not support 32-bit drivers
There's no 6.2.1 or 6.2.2 yet.
Just to be sure, there's no problem with 6.1.2 but you've got problem with 6.1.4 and 6.2.0?
It could be interesting to have the result with 6.1.3 so we'd know exactly from which LO version the pb appears.
Sorry, my mistake, last updates were 22.214.171.124 & 126.96.36.199 :(
I downgraded to version 188.8.131.52 from my original sources refreshing to a new User Profile through the FailSafe menu and I confirm that I have not the above mentioned error launching display of data in Tables, Views or Queries.
I then upgraded to version 6.1.3 and error re-appear with this version ...
Ok so the earliest version is 184.108.40.206 and it's a regression.
LibreOffice 220.127.116.11 is going to be released today, could you please try again
with this version to see if the problem has been resolved meanwhile? Thanks in
I recently installed in parallel Version 18.104.22.168 and bug is still present in this version.
I will try with version 22.214.171.124 when available and keep you posted.
I did a fresh install of version 126.96.36.199 and still get the same error # HYC00 - [Oracle][ODBC]Optional feature not implemented.
As before, list of Oracle Schemes, Tables or Views is displayed but error happen when I try to display data of these Tables or Views or Queries registered in a LibO Base file.
Note that all queries registered in the Base file are with the "Direct Execution of SQL Statement" feature enabled.