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