0

In the sqlplus script, I did this

unset NLS_LANG

How I can do the same thing for cx_oracle in jupyter notebook ?

I am following this example and got the error.

How can I access Oracle from Python?

DatabaseError: ORA-12705: Cannot access NLS data files or invalid environment specified
Mookayama
  • 1,243
  • 2
  • 14
  • 28

1 Answers1

0

I encountered the same error before and I ran below codes to set the language by running an alter command. Make sure you commit afterwards.

c.execute(u'ALTER SESSION SET NLS_LANGUAGE=American')
jose_bacoy
  • 12,227
  • 1
  • 20
  • 38