Can't view Hebrew data stored in your Oracle database using TOAD / PL/SQL developer ? That, also, is a well known problem with a very usually-it-works solution for Windows users: In order to be able to view Hebrew fonts properly from Oracle you need to set the NLS_LANG registry key. The key can be found here: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME ID \ NLS_LANG where ID is the unique number identifying the Oracle home . The right value of the key for Hebrew fonts is: HEBREW_ISRAEL.IW8MSWIN1255 The...
While working with oracle in .NET projects I came across one very annoying reoccurring problem: "Could not create an environment: OCIEnvCreate returned -1" Two things came up: 1 - permissions issue 2 - a missing ORACLE_HOME environment variable "Ever received this error message while trying to connect to a Oracle database from .Net and wondered why this is happening. Well, I was banging my head on my workstation for about a week. The whole internet pointed to the oracle bin folder not having permissions...