sql db.Exec fail to insert "" to blob,runtime error: index out of range

[hnzouzc]

table: create table blob_sample( id integer, payload blob);

gopkg.in/rana/ora.v4

func fatal(err error){ if err !=nil{ log.Fatal(err) } }

func testOracle(){ db ,err := sql.Open("ora","user/pwd@//127.0.0.1:1521/orcltest") fatal(err) defer db.Close() err = db.Ping() fatal(err) //ora.Cfg().Stm ids := []int64{2,3,4} datas := []string{"123443",""," "} for i:=0;i<len(ids);i++{ err := insertBlobDataByByte(db,ids[i],[]byte(datas[i])) if err !=nil{ fmt.Printf("fail to insert id:%d,data:%s,err:%v\n",ids[i],datas[i],err) continue } data,err:=readBlobDataByByte(db,ids[i]) if err!=nil{ fmt.Printf("fail to get id:%d,err:%v\n",ids[i],err) }else{ fmt.Printf("id:%d,data:%s,len:%d\n",ids[i],data,len(data)) } } }

func insertBlobDataByByte(db *sql.DB,id int64,abc []byte)error{ _,err := db.Exec("insert into blob_sample(id,payload)values(:1,:2)",id,abc) return err }

do import oracle init. ab is not empty, id:2,data:123443,len:6 fail to insert id:3,data:,err:Stmt.exeC.func1 recovered: runtime error: index out of range goroutine 1 [running]: gopkg.in/rana/ora%2ev4.getStack(0x0, 0x0) /mnt/e/gosrc/jpush-src-go-64/src/gopkg.in/rana/ora.v4/util.go:188 +0x92 gopkg.in/rana/ora%2ev4.errR(0xc421205490, 0x1, 0x1, 0xc4212054d0, 0x456aee) /mnt/e/gosrc/jpush-src-go-64/src/gopkg.in/rana/ora.v4/util.go:198 +0xe5 /opt/go/src/runtime/panic.go:502 +0x229 gopkg.in/rana/ora%2ev4.(bndBin).bind(0xc420200270, 0xc1abe0, 0x0, 0x0, 0x2, 0x0, 0x0, 0xc4200a4b40, 0x0, 0x0) /mnt/e/gosrc/jpush-src-go-64/src/gopkg.in/rana/ora.v4/bndBin.go:33 +0x24a gopkg.in/rana/ora%2ev4.(Stmt).bind(0xc4200a4b40, 0xc4201f2200, 0x2, 0x2, 0xffffffffffffff00, 0x1, 0x0, 0x0) /mnt/e/gosrc/jpush-src-go-64/src/gopkg.in/rana/ora.v4/stmt.go:941 +0x44ce gopkg.in/rana/ora%2ev4.(Stmt).exeC(0xc4200a4b40, 0x8419e0, 0xc4200120b0, 0xc4201f2200, 0x2, 0x2, 0x1000000, 0x0, 0x2, 0x0, ...) /mnt/e/gosrc/jpush-src-go-64/src/gopkg.in/rana/ora.v4/stmt.go:309 +0x342 gopkg.in/rana/ora%2ev4.(DrvStmt).ExecContext(0xc420206018, 0x8419e0, 0xc4200120b0, 0xc42124c0a0, 0x2, 0x2, 0x8, 0x0, 0x0, 0xc4212078d0) /mnt/e/gosrc/jpush-src-go-64/src/gopkg.in/rana/ora.v4/drvStmt_go1_8.go:46 +0x304 database/sql.ctxDriverStmtExec(0x8419e0, 0xc4200120b0, 0x841c60, 0xc420206018, 0xc42124c0a0, 0x2, 0x2, 0x2, 0x2, 0x0, ...) /opt/go/src/database/sql/ctxutil.go:65 +0x214 database/sql.resultFromStatement(0x8419e0, 0xc4200120b0, 0x8413e0, 0xc420022600, 0xc421207a78, 0xc421207d90, 0x2, 0x2, 0x0, 0x0, ...) /opt/go/src/database/sql/sql.go:2272 +0x198 database/sql.(DB).execDC(0xc4200a68c0, 0x8419e0, 0xc4200120b0, 0xc4200cc200, 0xc421207bf0, 0x80b931, 0x30, 0xc421207d90, 0x2, 0x2, ...) /opt/go/src/database/sql/sql.go:1410 +0x2bc database/sql.(DB).exec(0xc4200a68c0, 0x8419e0, 0xc4200120b0, 0x80b931, 0x30, 0xc421207d90, 0x2, 0x2, 0xc4201f2101, 0x20, ...) /opt/go/src/database/sql/sql.go:1371 +0x131 database/sql.(DB).ExecContext(0xc4200a68c0, 0x8419e0, 0xc4200120b0, 0x80b931, 0x30, 0xc421207d90, 0x2, 0x2, 0x20, 0x77ac40, ...) /opt/go/src/database/sql/sql.go:1349 +0xe1 database/sql.(DB).Exec(0xc4200a68c0, 0x80b931, 0x30, 0xc421207d90, 0x2, 0x2, 0xc1abe0, 0x0, 0x83e820, 0xc421207db0) /opt/go/src/database/sql/sql.go:1363 +0x85 main.insertBlobDataByByte(0xc4200a68c0, 0x3, 0xc1abe0, 0x0, 0x0, 0x0, 0x0) /mnt/e/gosrc/jpush-src-go-64/src/2018/toracle/main.go:141 +0x117 main.testOracle() /mnt/e/gosrc/jpush-src-go-64/src/2018/toracle/main.go:119 +0x193 main.main() /mnt/e/gosrc/jpush-src-go-64/src/2018/toracle/main.go:29 +0x70

[tgulacsi]

use gopkg.in/goracle.v2

[hnzouzc]

@tgulacsi thanks, it work well