What is your reason for changing the driver?
Because we are migrating from oracle 11g to 12c and the CF embedded driver does not work with oracle 12c.
For the next Question, yes we are planning to migrate the app to CF 11, but oracle is queued first.
CF9 does not support 12c. You will have to upgrade to CF11 before changing to 12C
haxtbh, Shall we run into some other issue rather than the driver if we use Oracle 12c with CF9, please educate if you see any other issue.
Further info, we are getting the above issue only on one server and the error details below,
ORA-00933: SQL command not properly ended.
As well as compatibility issues with CF9, the error you are getting is related directly to Oracle. You could be using outdated SQL that has now been fully depreciated in 12c. You will be better asking somewhere that helps with Oracle related queries.