Loading

No Data Returned From an Oracle View When Using NLS Language

Udgivelsesdato: Mar 30, 2026
Beskrivelse
When connecting to an Oracle View using NLS Language setting (such as  WHERE USERENV('LANG')= <Value>) from Tableau Desktop, no data is returned.

However when connecting from a different client application such as TOAD, data is returned.
Løsning

In order to resolve the issue it is necessary to change the NLS Language settings on the Data Source itself or use an ALTER initial SQL as follows: 

ALTER session SET nls_language=’AMERICAN’

 

Please note that the Initial SQL provided here is an example. Tableau Support is unable to assist with creating or troubleshooting Initial SQL - contact your Database Administrator for assistance if needed.

Vidensartikelnummer

001473362

 
Indlæser
Salesforce Help | Article