Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. go get github.com/mattn/go-oci8
  2.  
  3. prefix=/home/sbr/wk/apps/oracle/product/11.2.0/client_1
  4. exec_prefix=${prefix}
  5. libdir=${prefix}
  6. includedir=${prefix}/sdk/include
  7.  
  8. glib_genmarshal=glib-genmarshal
  9. gobject_query=gobject-query
  10. glib_mkenums=glib-mkenums
  11.  
  12. Name: oci8
  13. Description: oci8 library
  14. Libs: -L${libdir} -lclntsh
  15. Cflags: -I${includedir}
  16. Version: 11.2
  17.  
  18. package main
  19.  
  20. import (
  21. "fmt"
  22. "database/sql"
  23. _ "gopkg.in/goracle.v2"
  24. )
  25.  
  26. func main(){
  27.  
  28. db, err := sql.Open("goracle", "scott/tiger@10.0.1.127:1521/orclpdb1")
  29. if err != nil {
  30. fmt.Println(err)
  31. return
  32. }
  33. defer db.Close()
  34.  
  35.  
  36. rows,err := db.Query("select sysdate from dual")
  37. if err != nil {
  38. fmt.Println("Error running query")
  39. fmt.Println(err)
  40. return
  41. }
  42. defer rows.Close()
  43.  
  44. var thedate string
  45. for rows.Next() {
  46.  
  47. rows.Scan(&thedate)
  48. }
  49. fmt.Printf("The date is: %sn", thedate)
  50. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement