go-oci8 on windows64

go-oci8 on win64.md

Prerequisites

• Oracle Instant Client SDK
• 64-bit tdm-gcc

Create a file called oci8.pc

ora=<instaclient-install-dir>
gcc=<tdm-gcc-install-dir>

oralib=${ora}\\sdk\\lib\\msvc
orainclude=${ora}\\sdk\\include

gcclib=${gcc}\\lib
gccinclude=${gcc}\\include

Name: OCI
Description: Oracle database engine
Version: 12.1
Libs: -L${oralib} -L${gcclib} -loci
Libs.private: 
Cflags: -I${orainclude} -I${gccinclude}

Make sure to use \\ as the path separator

Setup environment

• set PATH=<tdm-gcc-install-dir>\bin;%PATH%
• set PKG_CONFIG_PATH=<path-to->\oci8.pc

Build your app

• go get github.com/mattn/go-oci8
• go build -x your-prog.go

Note: -x will show you the underlying gcc/ld commands, which is incredibly useful for debugging

Try with format export GO_OCI8_CONNECT_STRING=user/name@host:port/sid

I am using Windows 10. I did exactly as you described above but am getting the following error:

# pkg-config --cflags oci8
pkg-config: exit status 3221225595

My oci8.pc config file is as follows:

ora=C:\oracle\instantclient_12_2
gcc=C:\TDM-GCC-64

oralib=${ora}\sdk\lib\msvc
orainclude=${ora}\sdk\include

gcclib=${gcc}\lib
gccinclude=${gcc}\include

Name: OCI
Description: Oracle database engine
Version: 12.2
Libs: -L${oralib} -L${gcclib} -loci
Libs.private:
Cflags: -I${orainclude} -I${gccinclude}