sijms / go-ora

Pure go oracle client
MIT License
795 stars 176 forks source link

long type get a error(ORA-03146:invalid buffer length for TTC field) #543

Closed lvxiaorun closed 5 months ago

lvxiaorun commented 5 months ago

long type get a error(ORA-03146:invalid buffer length for TTC field)

oracle version is 19c and go-ora version is latest

The code is as follows

` var colStmt = "select column_expression from dba_ind_expressions where index_owner = 'xxx' and index_name = 'xxx' and column_position = 1" var exp string err = conn.QueryRow(colStmt).Scan(&exp) if err != nil { fmt.Println(err) }

fmt.Println("exp:",exp) `

sijms commented 5 months ago

fixed in next release

sijms commented 5 months ago

fixed v2.8.13

lvxiaorun commented 5 months ago

I tried it and it worked,thank you

lvxiaorun commented 5 months ago

as this code,it have a error "ORA-01009 missing mandatory parameter"

var colStmt = "select column_expression from dba_ind_expressions where index_owner = :1 and index_name = :2 and column_position = 1"
var exp string
err = conn.QueryRow(colStmt,"xxx","xxx").Scan(&exp)
if err != nil {
fmt.Println(err)
}

fmt.Println("exp:",exp)
sijms commented 5 months ago

all fixed in v2.8.14