473,507 Members | 2,389 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Re: Error While changing the session parameter NLS_LANG

amitvij78 <me*********@dbforums.comwrote in message news:<34****************@dbforums.com>...
I tried executing the following query.

alter session set NLS_LANG='UTF8';

I got the following error:

ORA-00922: missing or invalid option

Can anybody tell me how to do it?

I tried the following variation.

alter session set NLS_CALENDAR='ROC Official';

got the follwoing error:

ORA-12705: invalid or unknown NLS parameter value specified

I tried

alter session set NLS_CALENDAR='Gregorian';

This was done successfully.

Please advise me how to correctly execute the first query.

NLS_LANG is an environment variable (Unix) or a registry variable (Winblows)

Sybrand Bakker
Senior Oracle DBA
Jun 27 '08 #1
0 2306

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
3603
by: Tom | last post by:
Hi I am installing Oracle9ias onto a United Linux 1.0 and encountering the following error at "Single Sign On Configuration Assistant", any idea? .... PL/SQL procedure successfully...
0
9253
by: Gabo | last post by:
Hello, I have a VB front end program that connects to an Oracle backend db. Nothing has changed on either end; however, when I try to connect to the db via VB program I receive a requires OLE DB...
6
4712
by: Peter Frost | last post by:
Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much...
7
4179
by: Ottar | last post by:
I've made a program sorting incomming mail in public folder. The function runs every minute by using the form.timer event. In Access XP it runs for weeks, no problem. Access 2003 runs the same...
10
2681
by: Brian Conway | last post by:
I have no idea what is going on. I have a Login screen where someone types in their login information and this populates a datagrid based off of the login. Works great in debug and test through...
1
1374
by: John Ninan | last post by:
In my aspx Page i have asp.net combobox. It has different values. So i am generating usercontrol based on that. For example i have different flight leg in my combobox. I select first flight leg ,...
3
8814
by: Brian Foree | last post by:
I am developing an ASP.NET application that uses Access 2000 as its backend, and have just started getting the following error on 2 ASP.NET pages that had been working until late last week (and I...
7
3287
by: i | last post by:
#include<stdio.h> #include<conio.h> #include<process.h> #include<string.h> char ch; int w; int n,m; //void main(); char check(int n,int m,char ch); void cash(int n,int m,char ch);
0
254
by: bhallar | last post by:
NLS_LANG cannot be changed by alter session, NLS_LANGUAGE and NLS_TERRITORY can. -- Posted via http://dbforums.com
0
7223
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7321
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7377
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7488
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5623
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4702
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3191
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3179
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1544
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.