Oracle

•  http://gdal.org/ogr/drv_oci.html - format docs.

Building with Oracle Database Instant Client

It is generally necessary to put the instant client directory (which holds the shared libraries) in your LD_LIBRARY_PATH or equivelent *before* running configure. Use the --with-oci-lib and --with-oci-include options to specifically indicate the include and library directories. Often something like:

./configure 
    --with-oci-include=/home/warmerda/pkg/oracle_instantclient_11_2/sdk/include \
    --with-oci-lib=/home/warmerda/pkg/oracle_instantclient_11_2

On Linux, if you are using the  Instant Client and './configure' can not locate Oracle headers and libraries and throws in config.log a message saying:

/usr/bin/ld: cannot find -lclntsh

Then check if there is symbolic link with name libclntsh.so in <PREFIX>/lib pointing to binary with name like 'libclntsh.so.X.Y'. If it isn't there, create it using similar command to this:

$ ln -s /opt/instantclient_11_2/libclntsh.so.11.1 /opt/instantclient_11_2/libclntsh.so

Open Tickets

#1183

Oracle WKTEXT Translation

#1969

schema support for OGR ODBC

#2484

OCI driver does not seem to support date/time field combinations used by ESRI

#2667

Incorrect retrieving NUMBER width and precision for Oracle

#3025

OCI: Layer dimension not well detected on Oracle when 2D and 3D layers exists

#3131

ogr2ogr can not support the -append mode when import the normal dbf file to oracle

#3150

Precision Problem for Numeric on OGR/OCI driver

#3214

OCI fails when path includes '(x86)'

#3698

Failure when inserting some big geometries into OCI

#3753

Multipolygon with holes from OCI to PostgreSQL becomes invalid

#3754

ogr2ogr: Oracle spatial layer type is not recognized

#4093

gdalinfo returns negative values for the Bounding Corners

#4161

[PATCH] OGR OCI: Error in retrieving table dimension