Compiling and linking a program v17

Suggest edits

The EDB Open Client Library allows applications written using the Oracle Call Interface API to connect to and access an EDB database with minimal changes to the C source code. The EDB Open Client Library files are named:

  • On Linux: libedboci.so

  • On Windows: edboci.dll

The files are installed in the oci/lib subdirectory.

Compiling and linking a sample program in Linux

This example compiles and links the sample program edb_demo.c in a Linux environment. The edb_demo.c file is located in the oci/samples subdirectory.

  1. Set ORACLE_HOME to the complete pathname of the Oracle home directory, for example:

    export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

  2. Set EDB_HOME to the complete pathname of the home directory, for example:

    export EDB_HOME=/usr/edb

  3. Set LD_LIBRARY_PATH to the complete path of libpthread.so. By default, libpthread.so is located in /lib64.

    export LD_LIBRARY_PATH=/lib64/lib:$LD_LIBRARY_PATH

  4. Set LD_LIBRARY_PATH to include the EDB Postgres Advanced Server Open Client library. By default, libedboci.so is located in $EDB_HOME/oci/lib.

    export LD_LIBRARY_PATH=$EDB_HOME/oci:$EDB_HOME/oci/lib:$LD_LIBRARY_PATH

  5. Compile and link the OCL API program:

    cd $EDB_HOME/oci/samples
make

Compiling and linking a sample program in Windows

This example compiles and links the sample program edb_demo.c in a Windows 64-bit environment.

  1. In Visual Studio Code 64-bit for Windows, open a terminal.

  2. Change to the samples directory in the edb-oci installation directory:

    cd "c:\Program Files\edb\oci\samples"

  3. Compile the sample assuming Oracle headers are in c:\oracle_client\include\:

    cl edb_demo.c /I c:\oracle_client\include\ -D WIN32 /link /libpath:"c:\Program Files\edb\oci\lib\" edboci.lib

  4. Set the path to include the path to edb-oci dlls:

    set path=%path%;C:\Program Files\edb\oci\;C:\Program Files\edb\oci\lib

  5. Run the sample:

    edb_demo.exe
← Prev

Forming a connection string

↑ Up

Open Client Library

Next →

Ref cursor support