0

when I connect to an Oracle database, some symbols are not displayed properly. In Oracle I would change the nls_language parameter for the session using: alter session set nls_language and alter session set nls_territory But how can I change NLS_LANG and NLS_CHARACTERSET in SAS? I do not want to change the initora-parameters, the changes should be done only for my session.

Cœur
  • 37,241
  • 25
  • 195
  • 267
Jdzel
  • 159
  • 1
  • 3
  • 17
  • How do you connect to Oracle database? `LIBNAME` statment or library defined by administrator? – fl0r3k Aug 12 '16 at 13:10
  • Probably you should set an environment variable `NLS_LANG` for Oracle Client: http://docs.oracle.com/cd/E12102_01/books/AnyInstAdm784/AnyInstAdmPreInstall18.html – Robert Soszyński Aug 12 '16 at 13:14
  • I have a libname statement – Jdzel Aug 12 '16 at 13:21
  • 1
    Are you launching SAS yourself? Or are you connecting to an application server using Enterprise Guide, SAS/Studio or other tools? If you are launching it yourself, either on Linux or Windows, then you will have more control. But even then your system administrator might have hard coded NLS_LANG settings into command that launches SAS. – Tom Aug 12 '16 at 14:24
  • I am connecting to the server using SAS Enterprise Guide. Now I try to edit my libname statement. – Jdzel Aug 12 '16 at 15:46
  • I try to use DBCONINIT= option for this, but "ALTER SESSION SET NLS_CHARACTERSET" does not work. – Jdzel Aug 12 '16 at 15:51
  • Now I get an error "ORA-29275: partial multibyte character" while I am running a query to the Oracle table from SAS EG. I think its because of difference between NLS_LANG variables. – Jdzel Aug 12 '16 at 15:57
  • What language is your SAS session running in? – Joe Aug 12 '16 at 16:35
  • I have this options: LOCALE=EN_US ENCODING=WCYRILLIC – Jdzel Aug 12 '16 at 16:56

0 Answers0