Skip to Main Content

SQL Developer for VS Code

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!

ebs view FND_FLEX_VALUES_Vl with where T.LANGUAGE = userenv('LANG')

Daren JanesJul 24 2025

Where does the Plug-in get it's language environment setting from?

ebs 12.2 on DB 19C

The where clause in the ebs view with Language setting is tripping up the plug-in. Language setting issue of some sort.

and T.LANGUAGE = userenv('LANG');

The vscode sql developer plug-in

select userenv('LANG') from dual;

USERENV('LANG')
----------------------------------------------------
GB

sqlplus works fine but VS code plug-in having issues.

SQL> select userenv('LANG') from dual;

USERENV('LANG')
----------------------------------------------------
US

SQL>

This post has been answered by thatJeffSmith-Oracle on Jul 24 2025
Jump to Answer
Comments
Post Details
Added on Jul 24 2025
2 comments
55 views