Hi, I have one view in Oracle 11 that I just cannot convert to another format with ogr2ogr.
If I use -sql parameter "SELECT * FROM view" the conversion stops after couple of thousands of lines with the following error ERROR 1: ORA-01406: fetched column value was truncated in OCIStmtFetch I found this explanation from internet ORA-01406: fetched column value was truncated Cause: In a host language program, a FETCH operation was forced to truncate a character string. The program buffer area for this column was not large enough to contain the entire string. The cursor return code from the fetch was +3. Action: Increase the column buffer area to hold the largest column value or perform other appropriate processing. Could it be possible that OCI driver reserves too little of some resourses and fails because of that with large records? I am now running a query with minimum set of columns in my query and ogr2ogr is running well and I believe it will convert all the million rows from the view now. The view schema does not look extra hard for me. There are 21 attributes in the view and the longest VARCHAR2 is just 100 chararters long. -Jukka Rahkonen- _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev