5 Replies Latest reply on Jul 13, 2015 12:40 AM by haxtbh

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

    arunp67053767

      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