Evaluate new ODPI-C Oracle extension #819
Description
Is your feature request related to a problem? Please describe.
The current Oracle Oratcl extension is impact by a long-term Oracle bug on Windows that causes a crash with multiple threads and requires settings in SQLNET.ORA.
Describe the solution you'd like
There is a new extension for Oracle based on Tcl 9 https://github.com/bagnongithub/oratcl using Oracle's ODPI-C interface https://oracle.github.io/odpi/ this interface has the potential to resolve the existing issue and provided a more maintainable Oracle interface for HammerDB going forward.
Describe alternatives you've considered
N/A
Additional context
Initial evaluation showed the new interface built and loaded correctly when tested on Linux both Ubuntu and RedHat.
One key difference is that the new package is called oratcl and the previous one Oratcl and therefore would need a name change and is not a drop-in replacement. First tests show some syntax changes will also be needed:
Error in Virtual User 21: Error: wrong # args: should be "orabind statement-handle :name value ? :name value ... ?"
Solution would need extensive performance and reliability testing.
If evaluation succeeds it would need to be integrated with the existing Bawt system.