查询一条数据到结构体报错

[xiaotang0128]

err = db.Where("ID=?",1).First(&info).Error 报错，dpiStmt_execute:ORA-00933:SQL command not properly ended

[austin-millan]

Oracle 11 doesn't seem to support "FETCH" clause (introduced in Oracle 12). From the README:

Required dependency Install Oracle 12C+

The First clause produces the query here:

        if limit := limit.Limit; limit > 0 {
            builder.WriteString(" FETCH NEXT ")
            builder.WriteString(strconv.Itoa(limit))
            builder.WriteString(" ROWS ONLY")
        }

Which leads to the error:

SELECT * FROM TABLE WHERE ID = '1' ORDER BY TABLE.ID  FETCH NEXT 1 ROWS ONLY;
                                                      *
ERROR at line 1:
ORA-00933: SQL command not properly ended

Edit: This means you should avoid using First and Limit clauses in this library for versions < Oracle 12g.