[gdal-dev] Retreivinng a table with a condition using ogr2ogr OCI

[Jukka Rahkonen]

Even Rouault <even.rouault <at> spatialys.com> writes:


 
> Ammar,
> 
> it seems that the resulting layer from the SQL query is called "SELECT * FROM 
> TABLE WHERE ....", which is a bit an unfortunate choice (other drivers 
> generally call it "result" or "sql_statement", etc...
> Anyway, add "-nln the_layer_name_you_like" to avoid this.
> Alternatively you can add  -where "DETAILTYPE = 'Something'" in your first 
> ogr2ogr command that operates on the table, as opposed to a full SQL request.
 

If I read the command right:
"ogr2ogr 3011 -f "ESRI Shapefile" OCI:"user/password <at> ... "

it does not follow the ogr2ogr syntax as documented in
http://www.gdal.org/ogr2ogr.html

ogr2ogr .... dst_datasource_name src_datasource_name

The command is lacking the dst_datasource name. The real bug for my mind is
that ogr2ogr still tries to create an output. It should rather throw an
error "No destination defined".

Try with 
"ogr2ogr 3011 -f "ESRI Shapefile" output.shp OCI:"user/password <at>... "


-Jukka Rahkonen-