[gdal-dev] Error Oracle -lco options

[Stefano Iacovella]

Hi Simon,

try with this syntax:

ogr2ogr --debug on -a_srs EPSG:32198 -f OCI -nln mcc_test_sm -nlt POINT
–lco SRID=32198 –lco GEOMETRY_NAME=GEOM OCI:***/***@eddbd01
mcc_v_immobilisation_p.gml

Kind Regards,

Stefano

---------------------------------------------------
41.95581N 12.52854E


http://www.linkedin.com/in/stefanoiacovella

http://twitter.com/#!/Iacovellas


2013/8/5 Simon Mercier <smercier at mapgears.com>

>  Hi list
>
> I have to upload data  (same problem with shapefiles and gml) in Oracle
> with ogr2ogr and I got an error when I specify any -lco option.  If I don't
> add -lco in command line, data is uploaded without error.  Anyone have an
> idea?
>
> thank's
>
> ogr2ogr --version
>  GDAL 1.10.0, released 2013/04/24
>
> ogr2ogr --debug on -a_srs EPSG:32198 -f OCI OCI:***/***@eddbd01
> mcc_v_immobilisation_p.gml -nln mcc_test_sm -nlt POINT –lco SRID=32198 –lco
> GEOMETRY_NAME=GEOM
> GML: Using Expat reader
> GML: Using mcc_v_immobilisation_p.xsd
> OGR: OGROpen(mcc_v_immobilisation_p.gml/0x1ff1570) succeeded as GML.
> OCI: Userid=***, Password=***, Database=eddbd01
> OCI: Prepare(ALTER SESSION SET NLS_DATE_FORMAT='YYYY/MM/DD'
> NLS_TIME_FORMAT='HH24:MI:SS' NLS_TIME_TZ_FORMAT='HH24:MI:SS TZHTZM'
> NLS_TIMESTAMP_FORMAT='YYYY/MM/DD HH24:MI:SS'
> NLS_TIMESTAMP_TZ_FORMAT='YYYY/MM/DD HH24:MI:SS TZHTZM')
> OCI: Prepare(SELECT TABLE_NAME, OWNER FROM ALL_SDO_GEOM_METADATA)
> OCI: Prepare(SELECT COUNT(*) FROM ALL_SDO_GEOM_METADATA u,
> TABLE(u.diminfo) t  WHERE u.table_name = 'EOLIENNES_P' AND u.column_name =
> 'GEOM')
> OCI: Prepare(SELECT SRID FROM ALL_SDO_GEOM_METADATA WHERE TABLE_NAME =
> UPPER('EOLIENNES_P') AND COLUMN_NAME = UPPER('GEOM'))
> OCI: Prepare(SELECT WKTEXT, AUTH_SRID, AUTH_NAME FROM MDSYS.CS_SRS WHERE
> SRID = 4326 AND WKTEXT IS NOT NULL)
> OCI: Prepare(SELECT COUNT(*) FROM ALL_SDO_GEOM_METADATA u,
> TABLE(u.diminfo) t  WHERE u.table_name = 'SQL_STATEMENT' AND u.column_name
> = 'ORA_GEOMETRY')
> OCI: Prepare(SELECT SRID FROM ALL_SDO_GEOM_METADATA WHERE TABLE_NAME =
> UPPER('SQL_STATEMENT') AND COLUMN_NAME = UPPER('ORA_GEOMETRY'))
> OCI: Prepare(SELECT WKTEXT, AUTH_SRID, AUTH_NAME FROM MDSYS.CS_SRS WHERE
> SRID = 1000003006 AND WKTEXT IS NOT NULL)
> FAILURE: Couldn't fetch requested layer '–lco'!
> GDAL: In GDALDestroy - unloading GDAL shared library.
> **********
>
> --
> simon mercier
> co-fondateur solutions mapgears
> 2383 che ste-Foy bur 202 québec, qc
> canada G1V1T1
>
> t_418_476_7139#101
> m_418_559_7139simonmercier.net / mapgears.com
>
>
> _______________________________________________
> 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/20130806/e00f4675/attachment.html>