KNOWLEDGE BASE

No Data Returned From an Oracle View When Using NLS Language


Published: 01 Dec 2016
Last Modified Date: 22 Jun 2017

Issue

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.

Environment

  • Tableau Desktop
  • Oracle

Resolution

In order to resolve the issue it is necessary to change the NLS Language settings on the Data Source or use an ALTER initial SQL as follow: 
ALTER session SET nls_language=’AMERICAN’
Did this article resolve the issue?