[gdal-dev] ogr2ogr -f OCI fails on Windows

[Ivan Lucena]

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: landa.martin at gmail.com
> To: gdal-dev at lists.osgeo.org
> 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
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20140416/0e7abcee/attachment-0001.html>