[Gdal-dev] ORA-12705: invalid or unknown NLS parameter value specified

[Bart van den Eijnden]

Hi list,

just reporting this back in case anybody in the future runs into this.

When using ogr2ogr or ogrinfo on an OCI datasource I was getting:

D:\test>ogrinfo OCI:system/oracle at PORCL
ERROR 1: ORA-12705: invalid or unknown NLS parameter value specified
 in <unnamed>
ERROR 1: ORA-12705: invalid or unknown NLS parameter value specified
 in <unnamed>
FAILURE:

I got the NLS_LANG setting from the database using the following SQL:

SELECT name,value$ from sys.props$ where name like '%NLS_LANG%';

and then used an environment variable before calling ogrinfo:

D:\test>set NLS_LANG=AMERICAN

D:\test>ogrinfo OCI:system/oracle at PORCL
INFO: Open of `OCI:system/oracle at PORCL'
using driver `OCI' successful.

Best regards,
Bart


Bart van den Eijnden
Syncera IT Solutions
Postbus 270
2600 AG  DELFT

tel.nr.: 015-7512436
email: BEN at Syncera-ITSolutions.nl