ORA-00933: SQL command not properly ended. CF9 Error Executing Database Query, using ojdbc6 driver with Insert statement using select query.

Hi,

When using the CF9 in-build Oracle driver, the query works well, but when it is changed to use the ojdbc6.jar, then getting the below issue.

ORA-00933: SQL command not properly ended.

Issue particularly happens when we do an Insert using a select query inside cfquery. i.e.

INSERT INTO Table1
  (
  id
  , name
  , viewtime
  )
  SELECT
  tab_id as id
  , name
  , viewtime
  From Table2