Open ptitjano opened 8 months ago
I know very little about Oracle and the OCI driver, but I doubt this is an issue about quoting. Perhaps an issue with encoding, decimal separator, etc. ?
https://gdal.org/drivers/vector/oci.html mentions: "It might be necessary to define the environment variable NLS_LANG to "American_America.UTF8" to avoid issues with floating point numbers being truncated to integer on non-English environments."
You should try to reduce the error to the minimum SQL, with ogrinfo, probably only using to_number() on a literal or column
http://www.dba-oracle.com/sf_ora_01722_invalid_number.htm might also help
Steps to reproduce the problem.
The following command works correctly
with
points_ok.sql
:This command fails
with
point_ko.sql
:It returns the following error:
However,
point_ko.sql
is a valid sql statement. It looks like an issue with the single quotes.Operating system
Linux Debian stable / unstable
GDAL version and provenance
Tested with gdal 3.6.2 and 3.7.1