mnadel/go-oci8 on win64.md

Last active December 26, 2022 12:06

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/mnadel/8678269.js"></script>
Save mnadel/8678269 to your computer and use it in GitHub Desktop.

Download ZIP

go-oci8 on windows64

Raw

go-oci8 on win64.md

Prerequisites

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

ajaivar commented Mar 25, 2016

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

msaron commented Apr 17, 2018

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}