Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ALTER SESSION NS_LANG

602082Jul 5 2008 — edited Jul 5 2008
i need to set the NS_LANG parameter as AMERICAN_AMERICA.WE8MSWIN1252

i tried using the command
ALTER SESSION set NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252
ALTER SESSION set NLS_LANG=AMERICAN_AMERICA_.WE8MSWIN1252

But it didn't work out..can anyone help me please

Comments

Gary Graham-Oracle

I have not tested specifically on Linux, but it should behave the same as on Windows.  Basically...

0.  You must have a Java 8 JRE (public, standalone) or JDK installed.

1.  If PATH environment variable points to an Oracle client, SQLcl should automatically connect with OCI/Thick driver

2.  If not, then SQLcl connects with Thin driver.

Once connected, you can verify the connection type by running...

show connection

which will display something like...

CONNECTION

HR@jdbc:oracle:oci8:@ADC122PB

or...

CONNECTION:

HR@jdbc:oracle:thin:@(DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = myhost.mycompany.com)(PORT = 1521))    )    (CONNECT_DATA =

   (SERVICE_NAME = orcl.mycompany.com)    )  )

If it does not work on Linux as I describe above, then you can try passing the -oci flag when invoking SQLcl.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 2 2008
Added on Jul 5 2008
2 comments
20,285 views