Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- go get github.com/mattn/go-oci8
- prefix=/home/sbr/wk/apps/oracle/product/11.2.0/client_1
- exec_prefix=${prefix}
- libdir=${prefix}
- includedir=${prefix}/sdk/include
- glib_genmarshal=glib-genmarshal
- gobject_query=gobject-query
- glib_mkenums=glib-mkenums
- Name: oci8
- Description: oci8 library
- Libs: -L${libdir} -lclntsh
- Cflags: -I${includedir}
- Version: 11.2
- package main
- import (
- "fmt"
- "database/sql"
- _ "gopkg.in/goracle.v2"
- )
- func main(){
- db, err := sql.Open("goracle", "scott/tiger@10.0.1.127:1521/orclpdb1")
- if err != nil {
- fmt.Println(err)
- return
- }
- defer db.Close()
- rows,err := db.Query("select sysdate from dual")
- if err != nil {
- fmt.Println("Error running query")
- fmt.Println(err)
- return
- }
- defer rows.Close()
- var thedate string
- for rows.Next() {
- rows.Scan(&thedate)
- }
- fmt.Printf("The date is: %sn", thedate)
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement