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 fou
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
Eli Adam co.lincoln.or.us> writes:
>
> Jukka,
>
> > Could it be possible that OCI driver reserves too little of some
resoursesand
> > 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 wi
Jukka,
If the field is 17 char wide (rather than 17 bytes wide) then that is your
problem. A varchar2 column can use either char or byte specifications.
http://docs.oracle.com/cd/E11882_01/server.112/e26088/sql_elements001.htm#i
45694
If neither char or byte is specified, it defaults to your
NL
Jukka Rahkonen mmmtike.fi> writes:
> I suspect that the reason for the trouble is that this field is a
> 17 character wide VARCHAR2 and I have in the data values like
> "ÖVRE SÖDERGÄRDAN ". Database is using UTF-8 and Ö,Ö and Ä are
> taking more than one byte each. Perhaps OCI driver develops co
Jukka Rahkonen mmmtike.fi> writes:
>
> Jukka Rahkonen mmmtike.fi> writes:
>
> > I suspect that the reason for the trouble is that this field is a
> > 17 character wide VARCHAR2 and I have in the data values like
> > "ÖVRE SÖDERGÄRDAN ". Database is using UTF-8 and Ö,Ö and Ä are
> > taking more