<div dir="ltr"><div>Hi Simon,<br><br>try with this syntax:<br><br><span>ogr2ogr --debug on -a_srs EPSG:32198 -f OCI </span><span>-nln mcc_test_sm -nlt POINT –lco
SRID=32198 –lco GEOMETRY_NAME=GEOM</span> <span>OCI:***/***@</span><span>eddbd01
mcc_v_immobilisation_p.gml<br><br></span></div><span>Kind Regards,<br><br>Stefano<br></span></div><div class="gmail_extra"><br clear="all"><div>---------------------------------------------------<br>41.95581N 12.52854E<br>
<br><br><a href="http://www.linkedin.com/in/stefanoiacovella" target="_blank">http://www.linkedin.com/in/stefanoiacovella</a><br><br><a href="http://twitter.com/#!/Iacovellas" target="_blank">http://twitter.com/#!/Iacovellas</a></div>
<br><br><div class="gmail_quote">2013/8/5 Simon Mercier <span dir="ltr"><<a href="mailto:smercier@mapgears.com" target="_blank">smercier@mapgears.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Hi list<br>
<br>
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?<br>
<br>
thank's<br>
<br>
<span>ogr2ogr --version</span><br>
<span>
<span style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:start;font-style:normal;display:inline!important;font-weight:normal;float:none;line-height:normal;color:rgb(34,34,34);text-transform:none;font-size:small;white-space:normal;font-family:arial;word-spacing:0px">GDAL 1.10.0, released 2013/04/24<br>
</span><br>
ogr2ogr --debug on -a_srs EPSG:32198 -f OCI OCI:***/***@</span><span>eddbd01
mcc_v_immobilisation_p.gml -nln mcc_test_sm -nlt POINT –lco
SRID=32198 –lco GEOMETRY_NAME=GEOM</span><br style="color:rgb(34,34,34);font-family:arial;font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<span>GML: Using Expat
reader</span><br style="color:rgb(34,34,34);font-family:arial;font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<span>GML: Using
mcc_v_immobilisation_p.xsd</span><br style="color:rgb(34,34,34);font-family:arial;font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<span>OGR:
OGROpen(mcc_v_immobilisation_</span><span style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:start;font-style:normal;display:inline!important;font-weight:normal;float:none;line-height:normal;color:rgb(34,34,34);text-transform:none;font-size:small;white-space:normal;font-family:arial;word-spacing:0px">p.gml/0x1ff1570) succeeded as GML.</span><br>
<span>OCI: Userid=***,
Password=***, Database=eddbd01</span><br style="color:rgb(34,34,34);font-family:arial;font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<span>OCI: Prepare(ALTER
SESSION SET NLS_DATE_FORMAT='YYYY/MM/DD' </span><span>
NLS_TIME_FORMAT='HH24:MI:SS' NLS_TIME_TZ_FORMAT='HH24:MI:SS
TZHTZM' NLS_TIMESTAMP_FORMAT='YYYY/MM/</span><span>DD
HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT='YYYY/</span><span>MM/DD HH24:MI:SS
TZHTZM')</span><br style="color:rgb(34,34,34);font-family:arial;font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<span>OCI:
Prepare(SELECT TABLE_NAME, OWNER FROM ALL_SDO_GEOM_METADATA)</span><br>
<span>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')</span><br style="color:rgb(34,34,34);font-family:arial;font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<span>OCI:
Prepare(SELECT SRID FROM ALL_SDO_GEOM_METADATA WHERE TABLE_NAME =
UPPER('EOLIENNES_P') AND COLUMN_NAME = UPPER('GEOM'))</span><br>
<span>OCI:
Prepare(SELECT WKTEXT, AUTH_SRID, AUTH_NAME FROM MDSYS.CS_SRS
WHERE SRID = 4326 AND WKTEXT IS NOT NULL)</span><br style="color:rgb(34,34,34);font-family:arial;font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<span>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')</span><br style="color:rgb(34,34,34);font-family:arial;font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<span>OCI:
Prepare(SELECT SRID FROM ALL_SDO_GEOM_METADATA WHERE TABLE_NAME =
UPPER('SQL_STATEMENT') AND COLUMN_NAME = UPPER('ORA_GEOMETRY'))</span><br>
<span>OCI:
Prepare(SELECT WKTEXT, AUTH_SRID, AUTH_NAME FROM MDSYS.CS_SRS
WHERE SRID = 1000003006 AND WKTEXT IS NOT NULL)</span><br>
<span>FAILURE: Couldn't
fetch requested layer '–lco'!</span><br style="color:rgb(34,34,34);font-family:arial;font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<span>GDAL: In
GDALDestroy - unloading GDAL shared library.</span><span class="HOEnZb"><font color="#888888"><br>
<u></u><u></u><u></u><u></u><u></u><br>
<br>
<pre cols="72">--
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_7139
<a href="http://simonmercier.net" target="_blank">simonmercier.net</a> / <a href="http://mapgears.com" target="_blank">mapgears.com</a>
</pre>
</font></span></div>
<br>_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br></blockquote></div><br></div>