We assume you have rebar somewhere on your path. Rebar will take care of the Erlang and C++ sources. rebar compile Please check the rebar manual for how to add erloci as a dependency to your project.

The threadpool code (threadpool.cpp/h) is developed by Mathias Brossard mathias@brossard.org. His threadpool library is hosted at https://github.com/mbrossard/threadpool. This library is unused (not linked) in a Windows environment. For an easier installation process we include the required threadpool files in the erloci repo. So this is NOT a dependency you have to resolve by yourself.

OCI provides a high performance, native 'C' language based interface to the Oracle Database. There is no ODBC layer between your application and the database. Since we don't want to distribute the Oracle Code you MUST download the OCI Packages (basic and devel) from the Oracle Website: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html.

In order to successfully compile and link 'erloci' you must set the variables "CXXFLAGS" and "DRV_LDFLAGS" in rebar.config.

In our case we just created a folder 'lib' containing symlinks pointing to the downloaded libraries and header files.

Download from Oracle the following libraries (for correct target platfrom)

1. instantclient-basic
2. instantclient-sdk

Unzip and copy them to following directory structure

erloci
├── c_src
│   ├── lib
│   │   ├── instantclient
│   │   │   ├── libclntsh.* (linux/mac)
│   │   │   ├── libnnz11.*  (linux/mac)
│   │   │   ├── libocci.*   (linux/mac)
│   │   │   ├── libocci.*   (linux/mac)
│   │   │   ├── occi.lib    (windows)
│   │   │   ├── include
│   │   │   │   ├── *.h     (header files from sdk/include)

instantclient
├── libclntsh.dylib.11.1
├── libnnz11.dylib
├── libocci.dylib.11.1
├── libociicus.dylib
├── libocijdbc11.dylib
├── sdk
│   ├── include

Navigate to the Git repo path of ERLOCI from a Visual Studio Command Prompt and run the following: rebar.bat compile -C rebar.config.win

Please refer to rebar for further details on how to build rebar or rebar.bat in Windows.

{ok, Pool} = oci_session_pool:start_link("127.0.0.1", 1521, {service, "db.local"}, "dbauser", "supersecret",[]).
%% getting a new session from the pool. (parameterized module) 
Session = oci_session_pool:get_session(Pool).

%% execute_sql can execute INSERT, UPDATE, DELETE, and SELECT statements
MaxRowsToReturn = 10.
ok = Session:execute_sql("select * from test_erloci", [], MaxRowsToReturn).

%% in the case of the select, we can fetch MaxRowsToReturn rows at a time.
FirstTenRows = Session:get_rows().

%% as long as we have an 'open' select statement we can get the column information
Columns = Session:get_columns().

%% we can fetch the rows until we get an empty list
%% Session stays open and we can resuse it for further queries otherwise we close the session
Session:close().

%% if we are really done we shutdown the session pool
oci_session_pool:stop(Pool).

1. Better session and pool monitoring
2. Log handling
3. Improve testing