Friday, September 28, 2018

No data displayed for some tables EBS 12.2 with SQL Developer V18

No data displayed for some tables EBS with SQL Developer V18

when select data from some tables such as fa_additions using sql developper v18, no row displayed.

select * from fa_additions

No rows

This will not the only view showing no rows. but all synonyms for views creating with the T.LANGUAGE = userenv('LANG'); 

to check the nls lang from sql developer, 

select userenv('LANG') from dual;
GB.

To change the LANG in sql developer, please to
1. Start sqldeveloper.
2. Go to Tools-->preferences-->database-->NLS parameters.
3. Change LANGUAGE to AMERICAN.
4. Restart sql developer.

The data will displayed normally now.


No comments:

Post a Comment