ORA-00911: invalid character with go-ora and IN clause

[nenadnoveljic]

import ( "log" "github.com/jmoiron/sqlx" go_ora "github.com/sijms/go-ora/v2" )

connStr := go_ora.BuildUrl(HOST, PORT, SERVICE_NAME, USER, PASSWORD, map[string]string{})
db, err := sqlx.Open("oracle", connStr)
if err != nil {
log.Fatalf("open %s", err)
return
}
err = db.Ping()
if err != nil {
log.Fatalf("ping %s", err)
return
}
slice := []int{1}
query, args, err := sqlx.In("SELECT 1 FROM dual WHERE rownum IN (?)", slice)
if err != nil {
log.Fatalf("prepare %s", err)
}
_, err = db.Query(db.Rebind(query), args...)
if err != nil {
log.Fatalf("IN query %s", err)
}


IN query ORA-00911: invalid character

The same code works well with Godror.

[thomaskchan]

I ran into a similar issue, and I believe this is because the go-ora "oracle" driver doesn't have a default bind type.

I set this before the Rebind:

sqlx.BindDriver("oracle", sqlx.NAMED)

Otherwise, this can be fixed with #856.