Loading

No Data Returned From an Oracle View When Using NLS Language

Publiceringsdatum: Mar 30, 2026
Beskrivning
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.

Knowledge-artikelnummer

001473362

 
Laddar
Salesforce Help | Article