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 <[email protected]> > 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev >
_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
