My personal collection of oracle stuffs and sometimes non-oracle items too
Wednesday, January 18, 2017
SQLcl language setting in Windows environment
I have a PL/SQL procedure doing data dump to a file running it through sqlplus. It was working fine until I switch sqlplus to sqlcl and all numeric fields ended up like 123,45 instead of 123.45.
After googling, I found that it is a java issue and there is a setting for it.
I add the following line to sql.bat and that solved the problem.
set JAVA_TOOL_OPTIONS=-Duser.language=en -Duser.region=US -Dfile.encoding=UTF-8
No comments:
Post a Comment