<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'>Hi Martin,<br><br>Here is a list of the issues that I am planning to fix on that driver, once I have time, bur if you think they are important for you too we can share the work. The first item you have already started but you might think of adding that line to the session initialization:<br><div><br></div><div>1) Always create tables using VARCHAR2
specifications for character strings. Without this, loading into UTF8
databases is not possible. The simplest to achieve this is to execute
this statement when connecting:</div><div><br></div><div>ALTER SESSION SET NLS_LENGTH_SEMANTICS=CHAR</div><div><br></div><div>2) When loading a shape file <b>without</b>
any attributes, then the -<b>overwrite </b>parameter is ignored. When the
shape file has at least one attribute in the DBF file, then the
-overwrite parameter works fine: the OCI driver first drops the existing
table before re-creating it. Only when the input shape file has no attributes.</div><div><br></div><div>3) When reading a view, the name of the view name must be in <b>upper case</b><br><br></div>4) Add support for <b>LOB </b>attribute columns<br><br>5) Create the table with all the <b>column definition</b> at once instead of issuing one ALTER TABLE ADD COLUMN statement for each column<br><br>I have started with # 4 but I didn't get very far.<br><br>Regards,<br><br>Ivan<br><br><div>> Date: Fri, 2 May 2014 10:36:14 +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>> 2014-04-18 18:55 GMT+02:00 Ivan Lucena <lucena_ivan@hotmail.com>:<br>> > The driver should create the column as VARCHAR2, not VARCHAR [1]. It is<br>> > wrong for several reasons [2] and there is a possibility that the amount of<br>> > data you are loading is too big for the wrong data type. Can you change that<br>> > code [1], compile and try again?<br>> ><br>> > [1] -<br>> > [http://trac.osgeo.org/gdal/browser/trunk/gdal/ogr/ogrsf_frmts/oci/ogrociwritablelayer.cpp#L296]<br>> ><br>> > [2] """<br>> > The VARCHAR2 subtypes STRING and VARCHAR have the same range of values as<br>> > their base type. For example, VARCHAR is just another name for VARCHAR2.<br>> ><br>> > You can use the VARCHAR2 subtypes for compatibility with ANSI/ISO and IBM<br>> > types.<br>> <br>> thanks for the clarification. Changed in r27274. Martin<br></div> </div></body>
</html>