<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>The driver should create the column as VARCHAR2, not VARCHAR [1]. It is wrong for several reasons [2] and there is a possibility that the amount of data you are loading is too big for the wrong data type. Can you change that code [1], compile and try again?<br><br>[1] - [http://trac.osgeo.org/gdal/browser/trunk/gdal/ogr/ogrsf_frmts/oci/ogrociwritablelayer.cpp#L296]<br><br>[2] """<br>The <code>VARCHAR2</code> subtypes <code>STRING</code> and <code>VARCHAR</code> have the same range of values as their base type. For example, <code>VARCHAR</code> is just another name for <code>VARCHAR2</code>.<br><br>You can use the <code>VARCHAR2</code> subtypes for compatibility with ANSI/ISO and IBM types.<BR><br><BR>
Currently, <code>VARCHAR</code> is synonymous with <code>VARCHAR2</code>. However, in future releases of PL/SQL, to accommodate emerging SQL standards, <code>VARCHAR</code> might become a separate datatype with different comparison semantics. <u>It is a good idea to use <code>VARCHAR2</code> rather than <code>VARCHAR</code>.</u><BR>""" <br>[ <a href="http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/datatypes.htm#i42580" target="_blank">http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/datatypes.htm#i42580</a> ]<br><br><br><div>> Date: Fri, 18 Apr 2014 18:21:48 +0200<br>> Subject: Re: [gdal-dev] ogr2ogr -f OCI fails on Windows<br>> From: landa.martin@gmail.com<br>> To: lucena_ivan@hotmail.com<br>> CC: gdal-dev@lists.osgeo.org<br>> <br>> Hi,<br>> <br>> Dne 16. dubna 2014 22:37 Ivan Lucena <lucena_ivan@hotmail.com> napsal(a):<br>> <br>> > Could you try yo run that command in PLSQL before loading thata data?<br>> ><br>> > SQL> ALTER SESSION SET NLS_LENGTH_SEMANTICS=CHAR;<br>> <br>> I tried that and also setting environmental variable<br>> <br>> SET NLS_LENGTH_SEMANTICS=CHAR<br>> <br>> > And then ogr2ogr with -overwrite<br>> ><br>> > $ ogr2ogr -f OCI oci:user/passwd data\20140331_OB_564729_UKSH.xml.gz<br>> > -overwrite<br>> <br>> but I don't see any extra info compared to that I already sent. Could<br>> it be related to<br>> <br>> Warning 6: Can't create field DetailniTEAKod with type IntegerList on<br>> Oracle layers. Creating as VARCHAR.<br>> OCI: Prepare(ALTER TABLE STAVEBNIOBJEKTY ADD "DetailniTEAKod" VARCHAR(2047))<br>> <br>> ? Thanks, Martin<br></div> </div></body>
</html>