SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Changing language to English impacts SQL results on views

Vincent NagyAug 5 2019 — edited Aug 7 2019

Hi,

I use SQL Developer 19.2.0.206 and my desktop environment is in French.

I wanted to avoid confusion as exchanging info and screenshots using SQL Developer, so I added the line below to have this software in English.

I add AddVMOption -Duser.language=en in sqldeveloper/bin/sqldeveloper.conf file

SQL Developer user interface is now in English but since I experience issues at retrieving records from Oracle database. Several views of Oracle EBS R12 and ASCP don't provide any record.

For example with the following statement on Oracle ASCP: SELECT * FROM apps.MSC_ORDERS_V

2019-08-05 09_36_19-Oracle SQL Developer _ ITRPA.png

As I comment the conf line to use back the French interface, the view provides the relevant results:

2019-08-05 09_36_34-Oracle SQL Developer _ ITRPA.png

Could you please guide me on how to change the language to English in SQL Developer and avoid such side-effects?

Regards,

Vincent

Added on Aug 5 2019

#sql-developer

1 comment

546 views