538: open c1('NLS_LANGUAGE');
539: fetch c1 into L1;
540: close c1;
541: if (L1<>l_nls_language) then
542: sys.dbms_session.set_nls('NLS_LANGUAGE',l_nls_language);
543: end if;
544: open c1('NLS_TERRITORY');
545: fetch c1 into L1;
546: close c1;
544: open c1('NLS_TERRITORY');
545: fetch c1 into L1;
546: close c1;
547: if (L1<>l_nls_territory) then
548: sys.dbms_session.set_nls('NLS_TERRITORY',l_nls_territory);
549: end if;
550:
551: IF (l_debug = 'Y') THEN
552: okc_debug.Log('1000: Leaving ',2);