Hello,
I have a trouble with setting NLS_LANG variable for oci8 support.
I tried practically all ways described here in previous postings and in other places found via google.com but without any positive effect.
At first I tried to set this variable via
putenv("NLS_LANG=RUSSIAN_UKRAINE.CL8KOI8R");
as a result ocilogon couldn't login with error ORA-12705.
perl scripts with the same value work without any errors.
Then, I tried
"ALTER SESSION SET NLS_LANG=RUSSIAN_UKRAINE.CL8KOI8R"
It returned me "ORA-00922: missing or invalid option".
Our DBA said that I cannot alter NLS_LANG variable using ALTER SESSION.
At last I decided to set this variable in httpd.conf (apache) for my virtual server. I put all environment variables needed for oci8 and checked them via getenv function. All values are right and variables are exported to php script, but they still ignored by oci8. So this approach didn't solve my problem too.
I don't want to try to set NLS_LANG in script before apache starts - there are a lot of other applications written in jsp which works fine.
If you have other solutions for this problem or any ideas which could help me, I will appriciate your help.
Looking forward to any answers...
