ORA-00942 & ORA-24374 GET_DIMS with ogr2ogr 1.8.1

[djamel]

Hi

I installed a newer versin of ogr2og (1.8.1) using the OSGeo4W Installer.

When I export a table to a shapefile I get following errors: With the previous version (1.6.3) I didn't get these errors.

C:\oracle\product\11.1.0\client_1\BIN>ogr2ogr -f "ESRI Shapefile" "C:\temp\OGR2OGR\export.shp" OCI:myuser/mypwd@myenv.world -sql "SELECT * from mytable" -nlt POLYGON ERROR 1: ORA-00942: table or view does not exist in SELECT a.GEOM.GET_DIMS() DIM FROM GIS_OBJCT_MERGE a WHERE ROWNUM = 1 ERROR 1: ORA-24374: define not done before fetch or execute and fetch in OCIStmtFetch ERROR 1: ORA-00942: table or view does not exist in SELECT a.GEOM.GET_DIMS() DIM FROM GIS_OBJCT_LARGE a WHERE ROWNUM = 1 ERROR 1: ORA-24374: define not done before fetch or execute and fetch in OCIStmtFetch ERROR 1: ORA-00942: table or view does not exist in SELECT a.GEOM.GET_DIMS() DIM FROM VA_LB_PRC_GUID_MV a WHERE ROWNUM = 1 ERROR 1: ORA-24374: define not done before fetch or execute and fetch in OCIStmtFetch ERROR 1: ORA-04043: object EVA.EVA_GEO_PERCEEL_V does not exist in OCIDescribeAny ERROR 1: ORA-04043: object EVA.EVA_BUUR_PERCELEN_HUIDIG_V does not exist in OCIDescribeAny

Grts,

Djamel

[jef]

quite dated. probably fixed in later gdal package. And osgeo4w comes with it's own client - running from another clients bin directory might introduce different version of the oci.dll.