Reputation: 83
I have perl script that uses DBD::Oracle to run a query and print the results. When I tried access through apache or the terminal I receive the same error. ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH (Windows) and or NLS settings, permissions, etc.
So I set ORACLE_HOME environment variable and it works fine from the terminal but the apache throws the same. Any suggestions?
Upvotes: 2
Views: 6896
Reputation: 2342
It seems like your apache can't find ORACLE_HOME. Try setting ORACLE_HOME variable in the envvars file located in apache home dir: export ORACLE_HOME=/path/to/oracle/home
Upvotes: 3