[osgeo4w-dev] [osgeo4w] #268: ORA-00942 & ORA-24374 GET_DIMS with ogr2ogr 1.8.1

[OSGeo4W]

#268: ORA-00942 & ORA-24374 GET_DIMS with ogr2ogr 1.8.1
-------------------+--------------------------------------------------------
Reporter:  djamel  |       Owner:  osgeo4w-dev@…              
    Type:  defect  |      Status:  new                        
Priority:  major   |   Component:  Package                    
 Version:          |    Keywords:                             
-------------------+--------------------------------------------------------
 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 at 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

-- 
Ticket URL: <http://trac.osgeo.org/osgeo4w/ticket/268>
OSGeo4W <http://trac.osgeo.org/osgeo4w>
OSGeo4W is the Windows installer and package environment for the OSGeo stack.