[gdal-dev] Issue with OCI driver

[san619]

i tried to extract shapefile data table from oracle to shapefile.
But im getting error : 

*Can't transform coordinates, source layer has no
coordinate system.  Use -s_srs to set one.
ERROR 1: Terminating translation prematurely after failed
translation from sql statement.*

I tried exporting using command 
*ogr2ogr -f OCI OCI:user/password at ip/servicename -a_srs EPSG:2180
"C:Downloads\pas_ochronny\pas ochronny.shp"*

The file got uploaded successfully.But when im trying to extract the table
to shapefile im getting error.
I used the command 
*
ogr2ogr -f "GEOJSON" "PRO.json" OCI:user/password at ip/servicename   -t_srs
EPSG:4326  -sql "SELECT * FROM  PAS_OCHRONNY"*
but im getting the error Can't transform coordinates, source layer has no
coordinate system.  Use -s_srs to set one.
ERROR 1: Terminating translation prematurely after failed
translation from sql statement.
 But when is used the command 
*ogr2ogr -f "GEOJSON" "PROPERTYs.json"  OCI:user/password at ip/servicename
-s_srs EPSG:2180 -t_srs EPSG:4326  -sql "SELECT *  FROM PAS_OCHRONNY"*

Translation got successful.Why like this.
How to set the source layer coordinates while uploading.
Is there any way to reproject any source datum to EPSG:4326 without knowing
source.









--
Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html