[gdal-dev] Error Oracle -lco options

Simon Mercier smercier at mapgears.com
Mon Aug 5 12:21:40 PDT 2013


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_7139
simonmercier.net / mapgears.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20130805/9e3a21ac/attachment.html>


More information about the gdal-dev mailing list