Stack Overflow
Stack Overflow

Questions tagged [nls-lang]

NLS_LANG is a client side environment variable used to define language, territory and character set properties and to specify the locale behavior.

64 questions
1
vote
2 answers

NLS_NUMERIC_CHARACTERS reset when accessed from weblogic datasource

I have problem with certain code and the root cause turned out to be NLS_NUMERIC_CHARACTERS setting at session level. when I run the query directly on database: SQL> select 'nls_database_parameters' , p.* from nls_database_parameters p where…
user1933888
  • 2,897
  • 3
  • 27
  • 36
1
vote
1 answer

Insert/Update SQL queries for decimal separator comma in NLS_NUMERIC_CHARACTERS

I need to create bulk insert/update queries for which it is necessary to pass ORACLE SQL queries in string format, and I cannot use parametrized queries, because of some performance issue in SQL query string parsing in Delphi. My concern is, while…
jetty
  • 859
  • 2
  • 17
  • 37
1
vote
2 answers

Changing my oracle NLS_Lang environment

I need to format a string ot date including abbreviated strings. I tried with: to_date('Fri Jul 24', 'DY MON DD') It doesn't work, I figured it was because my oracle NLS parameters are set to French I have no idea why: SELECT * FROM…
kaligne
  • 3,098
  • 9
  • 34
  • 60
1
vote
1 answer

Python: Decoding NLS encoded text

I'm using a Corba library where the target returns error messages with NLS encoding. e.g: wideNlsText=u'$NLS[30822b0b\x01888\x01$NLS[30822ae5\x013\x01Subscriber NPA]NLS$]NLS$' Other than $NLS starts and NLS$ ends the string, what can I do to…
user3073001
  • 269
  • 3
  • 13
1
vote
2 answers

Thai language Configuration in Oracle

I have an issue regarding configuring Thai language in oracle (PL/SQL Developer). I have configured Thai language 'AMERICAN_AMERICA.TH8TISASCII' in regedit. Also I configured Environment variables in my computer. But still when I connect PL/SQL…
muhammad umar
  • 11
  • 1
  • 1
  • 4
1
vote
0 answers

When i change NLS ora gives "ORA-00979: not a GROUP BY expression" error

My Oracle NLS parameters is: NLS_SORT = TURKISH NLS_COMP= BINARY COLUMNA1=VARCHAR2 query: SELECT COLUMNA1, (SELECT TABLEB.COLUMB1 FROM TABLEB WHERE TABLEB.COLUMNB2 = TABLEA.COLUMNA1) FROM TABLEA GROUP BY TABLEA.COLUMNA1 This query worked…
Pisagor
  • 147
  • 1
  • 2
  • 16
1
vote
0 answers

Using NLS GERMAN shows wrong sorted output(load in chunks) in oracle

[ORACLE DATABASE] After setting, alter session set nls_sort = GERMAN; alter session set nls_language = GERMAN; When loading data in chunks and while using '>' to compare in order to get different sorted chunks shows incorrect data(gives duplicate…
parth manvar
  • 13
  • 5
1
vote
3 answers

How to produce the same result of to_char() on the same DB instance, but from different sessions?

I have a small utility function that calculates the day of week from a given date: select to_number(to_char(to_date('20130330', 'YYYYMMDD'),'D')) from dual; Executing this statement on the same database instance, but from two different machines it…
onlyhuman
  • 381
  • 3
  • 10
1
vote
1 answer

Setting oracle NLS_LANG for a JPA query

I need to access an oracle database view that require a certain nls_lang to be set - if it's not, an index will not be used and the database will lock up pretty much forever. I know this is bad joke design wise, but it is nothing I can change. I can…
Rasmus Franke
  • 4,434
  • 8
  • 45
  • 62
0
votes
4 answers

Week start from Sunday while calculating weekday

I am trying to find the weekday for Sunday to Saturday. In oracle by default Monday is the first day of the week. So When I calculate weekday with following query Select to_char(sysdate, 'D') from dual as today is 09/12/2022 this is giving me…
deepankar srigyan
  • 47
  • 1
  • 9
0
votes
0 answers

Getting error: Cannot access NLS data files or invalid environment specified

Wrote a simple query for post api which is as follows: SELECT * FROM TEST2 t WHERE t.correlation_id = 1; However, getting the error that can not access nls datafiles or environment specified. Unable to understand how to resolve this. I am working at…
Wajih Haider
  • 107
  • 7
0
votes
0 answers

NLS_LANG issue for two Oracle Homes on the same host, not refreshing the System and User Environment

I have tow Oracle 6i - Patch 17 applications running on the same host. Befoe they used to run on two different Windows installation for each one; but this is not conveniant. Each application is developed by a different company. I managed to install…
Guru
  • 42
  • 7
0
votes
1 answer

How set NLS_LANG for every connection (ojdbc8)

I using java application and using ojdbc8 to connecting to DB and I have a legacy database set with NLS_LANG set to CL8ISO8859P5. This I cannot change. And i got problem, when i sending data to DB, it`s replacing unknow characters like « and » to…
Daniil Baev
  • 69
  • 1
  • 8
0
votes
1 answer

Not visible and searchable Polish characters

I have a question to you. I have table where I'm saving names of groups and I can save name with polish characters but this saving like this: id name 123 Zarny When my name is Żarny. And when I do select something like this SELECT * …
Ashby
  • 51
  • 2
0
votes
0 answers

Arabic characters appears reversed - access DB2 AS400 using ORACLE gateway ODBC

I'm trying to access DB2 on AS400 from oracle database using oracle gateway for ODBC. I'm using the IBM i Access for windows as ODBC driver. my initdg4odbc.ini gateway configuration is: HS_FDS_CONNECT_INFO =…
Mhd Nour
  • 1
  • 2
1 2
3
4 5