(Read-only) The SESSION_NLS_LANGUAGE option is an OLAP session-wide, option that holds the value of NLS_LANGUAGE when the value of STATIC_SESSION_LANGUAGE is NO; or, when the value of STATIC_SESSION_LANGUAGE is YES, the value of NLS_LANGUAGE the last time that the value of STATIC_SESSION_LANGUAGE was NO.
See also:"Working with Language Dimensions", $DEFAULT_LANGUAGE, LOCK_LANGUAGE_DIMS, and STATIC_SESSION_LANGUAGE, "NLS Options"
For examples of retrieving how the value of SESSION_NLS_LANGUAGE is impacted by changes in the value of NLS_LANGUAGE and STATIC_SESSION_LANGUAGE, see Example 8-9, "Changing NLS_LANGUAGE" and Example 24-43, "Changing NLS_LANGUAGE Without Changing the Language of the OLAP Session".
Assume that you have two analytic workspace, one named
myaw3 and another named
myaw4. Assume also, as shown in the following code, that they both have language dimensions named
mylangs and that the languages for
myaw3are American and French and that the languages for
myaw4 are American and German.
REPORT myaw3!mylangs MYLANGS -------------- AMERICAN FRENCH REPORT myaw4!mylangs MYLANGS -------------- AMERICAN GERMAN
Now assume that you attach both of these analytic workspaces while NLS_LANGUAGE and SESSION_NLS_LANGUAGE are set to American. As shown in the following code, Oracle OLAP limits
mylangs in both analytic workspace to American.
REPORT myaw3!mylangsMYLANGS--------------AMERICANREPORT myaw4!mylangsMYLANGS--------------AMERICAN