We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
` package main
import ( "fmt" "gopkg.in/rana/ora.v4" )
/*
CREATE TABLE testB ( userid VARCHAR2(64), sid VARCHAR2(64), addtime DATE )
insert into TESTB (USERID, SID, ADDTIME) values ( 'A2561273', '99', to_date( '2018-10-11 12:18:55', 'YYYY-MM-DD HH:MI:SS' ) )
*/
func main() {
dsn := fmt.Sprintf( "%s/%s@%s:%s/%s", "u_sqldev", "ofcard025", "172.21.4.253", "1521", "ofdb", ) env, srv, ses, err := ora.NewEnvSrvSes(dsn) if err != nil { fmt.Printf("初始化连接池失败 => [%s] [%v]", dsn, err) return } //conPool := env.NewSrvPool(srv.Cfg(), 2) pool := env.NewPool(srv.Cfg(), ses.Cfg(), 2) session, err := pool.Get() if err != nil { fmt.Printf("初始化连接池失败1 => [%s] [%v]", "", err) return } defer session.Close() //session.PrepAndExe("ALTER SESSION SET CURRENT_SCHEMA=QMUC ") var i int = 0 for { i++ sql := "select * from QMUC.TB_USER_SCENE_REL where id = '201810110710554057978'" result, err := session.PrepAndQry(sql) if err != nil { return } for { row := result.NextRow() if row == nil { break } else { fmt.Println("sid:",i,row[0],row[1], row[2],row[3]) } } if i > 100 { break } }
}
`
hi, I found serious bugs above v4.1.15,The same row of data, some fields may not get values, The result after my execution is like this
` sid: 1 201810110710554057978 A2561273 99 2018-10-11 19:18:55 +0800 +08:00 sid: 2 201810110710554057978 A2561273 99 sid: 3 201810110710554057978 A2561273 99 sid: 4 201810110710554057978 A2561273 99 sid: 5 201810110710554057978 A2561273 2018-10-11 19:18:55 +0800 +08:00 sid: 6 201810110710554057978 A2561273 99 sid: 7 201810110710554057978 A2561273 99 sid: 8 201810110710554057978 A2561273 99 sid: 9 201810110710554057978 A2561273 99 sid: 10 201810110710554057978 A2561273 99 ...
The text was updated successfully, but these errors were encountered:
ora is the best golang-based oracle driver library I use now, please don't give up !
Sorry, something went wrong.
No branches or pull requests
`
package main
import (
"fmt"
"gopkg.in/rana/ora.v4"
)
/*
CREATE TABLE testB (
userid VARCHAR2(64),
sid VARCHAR2(64),
addtime DATE
)
insert into
TESTB (USERID, SID, ADDTIME)
values
(
'A2561273',
'99',
to_date(
'2018-10-11 12:18:55',
'YYYY-MM-DD HH:MI:SS'
)
)
*/
func main() {
}
`
hi, I found serious bugs above v4.1.15,The same row of data, some fields may not get values,
The result after my execution is like this
`
sid: 1 201810110710554057978 A2561273 99 2018-10-11 19:18:55 +0800 +08:00
sid: 2 201810110710554057978 A2561273 99
sid: 3 201810110710554057978 A2561273 99
sid: 4 201810110710554057978 A2561273 99
sid: 5 201810110710554057978 A2561273 2018-10-11 19:18:55 +0800 +08:00
sid: 6 201810110710554057978 A2561273 99
sid: 7 201810110710554057978 A2561273 99
sid: 8 201810110710554057978 A2561273 99
sid: 9 201810110710554057978 A2561273 99
sid: 10 201810110710554057978 A2561273 99
...
`
The text was updated successfully, but these errors were encountered: