79564062

Date: 2025-04-09 10:16:19
Score: 0.5
Natty:
Report link

In case the results differ when using command line sqlplus instead SQLDevelper it means they are configured to use different NLS_LANG. This happens always when the DB is set in Italian and you are using sqlplus installed on a server with Windows server in English with default settings.

It is possible to avoid the issue by setting the Italian NLS_LANG using the SET and EXPORT commands on in command prompt on the server:

SET NLS_LANG=ITALIAN_ITALY.UTF8

EXPORT NLS_LANG

SQLPLUS username@userpass/sid @D:\WORK\SKED\scriptfile.sql

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Low reputation (0.5):
Posted by: A. Lion