[gdal-dev] Oracle Connection issues

[Mateusz Loskot]

abhay menon wrote:
> Hi Bruce,
> 
> Just quick answer to 1 question...
> 
> The Client version of Oracle 10g R2 do have some issue of it own. Still
> the difference in the API of Oracle 9i to 10g is at large ( especially
> OCI and OCCI api). As a suggestion I would recommend you to use the same
> version of oracle as that of the client system.
> 
> Saying that 10.2.x.x and 10.1.x.x are also varying from each other too.
> I have past experience of running into trouble with them as well (i.e.
> not in GDAL/OGR context). But for implementation with OGR for pulling or
> pushing data to Oracle have been successful. So try using either 10.1 or
> 10.2 version of Oracle Client.

I agree, though this table presents quite good compatibility across OCI
versions:

http://www.tar.hu/sqlbible/sqlbible0121.html

> Note :.
> The structure validation and memory implementation is more of part of
> OCI than of OGR ( Mateusz correct me, if am wrong ).

The OGR OCI driver does open & read Oracle spatial tables and caches
their schema definition. So, it's may be faster to provide table list
when connecting, to build the cache faster and smaller.
If a database consits of large number of spatial tables, it may take a
longer while to collect all this information.

Regards
-- 
Mateusz Loskot, http://mateusz.loskot.net
Charter Member of OSGeo, http://osgeo.org