[gdal-dev] ORA-01406 error when reading many attributes from Oracle

[Eli Adam]

Jukka,

> 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.

This may be overly simplistic, but does the cast operator do anything?

SELECT *, CAST(OGR_STYLE AS character(255)) FROM rivers

Eli

>
> -Jukka Rahkonen-
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev