Why Are NLS Parameters Affecting Queries Over A Database Link?
Greetings,
Recently we have experienced a problem when running some SQL queries over one of our database links, where users are not able to retrieve any data from tables that are containing many rows.
Whilst investigating using SQL*Plus, I was able to retrieve results using exactly the same queries, which was confusing. After looking into it further however, I again ran the same queries via SQL Developer, and could not retrieve any rows.
So this lead to looking at differences between my nls_session_parameters in SQL*Plus and SQL Developer, and isolating that the problem was caused by a different setting for the NLS_LANGUAGE parameter. After changing the value for NLS_LANGUAGE in SQL Developer from 'FINNISH' to 'AMERICAN', the problem was immediately resolved.
Recently we have experienced a problem when running some SQL queries over one of our database links, where users are not able to retrieve any data from tables that are containing many rows.
Whilst investigating using SQL*Plus, I was able to retrieve results using exactly the same queries, which was confusing. After looking into it further however, I again ran the same queries via SQL Developer, and could not retrieve any rows.
So this lead to looking at differences between my nls_session_parameters in SQL*Plus and SQL Developer, and isolating that the problem was caused by a different setting for the NLS_LANGUAGE parameter. After changing the value for NLS_LANGUAGE in SQL Developer from 'FINNISH' to 'AMERICAN', the problem was immediately resolved.
0