<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>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>And then ogr2ogr with -overwrite<BR> <BR>$ ogr2ogr -f OCI oci:user/passwd data\20140331_OB_564729_UKSH.xml.gz -overwrite<br> <BR>Regards,<BR> <BR>Ivan<BR> <BR><div>> Date: Wed, 16 Apr 2014 19:17:31 +0200<br>> From: landa.martin@gmail.com<br>> To: gdal-dev@lists.osgeo.org<br>> Subject: [gdal-dev] ogr2ogr -f OCI fails on Windows<br>> <br>> Hi all,<br>> <br>> when trying to convert selected GML layer to Oracle spatial<br>> <br>> ogr2ogr -f OCI oci:user/passwd data\20140331_OB_564729_UKSH.xml.gz<br>> StavebniObjekty -overwrite -lco srid=2065<br>> <br>> the command fails with<br>> <br>> Podpis problému:<br>> Název události problému: APPCRASH<br>> Název aplikace: ogr2ogr.exe<br>> Verze aplikace: 0.0.0.0<br>> Časové razítko aplikace: 534e730f<br>> Název chybného modulu: kernel32.dll<br>> Verze chybného modulu: 6.0.6002.19034<br>> Časové razítko chybného modulu: 52f2ecb1<br>> Kód výjimky: c0000005<br>> Posun výjimky: 0001e743<br>> Verze operačního systému: 6.0.6002.2.2.0.274.10<br>> ID národního prostředí: 1029<br>> Další informace 1: f931<br>> Další informace 2: 90179027e379dba7ee23240ddb71d080<br>> Další informace 3: aad6<br>> Další informace 4: c968bb9711c76b26ad52f41a001dfb9d<br>> <br>> Debug:<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>> GML: ResetReading()<br>> GML: ResetReading()<br>> OCI: Prepare(INSERT INTO<br>> "STAVEBNIOBJEKTY"("OGR_FID","gml_id","Kod","Nespravny","CisloDomovni","IdentifikacniParcelaId","TypStavebnihoObjektuKod","ZpusobVyuzitiKod","CastObceK<br>> od","MomcKod","PlatiOd","PlatiDo","IdTransakce","GlobalniIdNavrhuZmeny","IsknBudovaId","Dokonceni","DruhKonstrukceKod","ObestavenyProstor","PocetBytu","PocetPodlazi","Podlahov<br>> aPlocha","PripojeniKanalizaceKod","PripojeniPlynKod","PripojeniVodovodKod","VybaveniVytahemKod","ZastavenaPlocha","ZpusobVytapeniKod","ZpusobOchranyKod","ZpusobOchranyTypOchra<br>> nyKod","ZpusobOchranyIdTransakce","ZpusobOchranyRizeniId","DetailniTEAKod")<br>> VALUES ( :fid , :field_0, :field_1, :field_2, :field_3, :field_4,<br>> :field_5, :field_6, :fiel<br>> d_7, :field_8, :field_9, :field_10, :field_11, :field_12,<br>> :field_13, :field_14, :field_15, :field_16, :field_17, :field_18,<br>> :field_19, :field_20, :field_21, :fi<br>> eld_22, :field_23, :field_24, :field_25, :field_26, :field_27,<br>> :field_28, :field_29, :field_30) )<br>> OCI: Prepare(SELECT MAX("OGR_FID") FROM "STAVEBNIOBJEKTY")<br>> <br>> Any idea? Thanks in advance! Martin<br>> <br>> -- <br>> Martin Landa * http://geo.fsv.cvut.cz/gwiki/Landa<br>> _______________________________________________<br>> gdal-dev mailing list<br>> gdal-dev@lists.osgeo.org<br>> http://lists.osgeo.org/mailman/listinfo/gdal-dev<br></div> </div></body>
</html>