note 21901 modified in ref.oci8 by sixd

I spent several hours tracking down error ORA 24374, which would result from only *SOME* of my select statements. This error would be caused if I made a query that would return any non-numerical value. I am running an Apache 1.3.x webserver and PHP 4.2.1. The fix is to add entries in your httpd.conf file that would export your environment settings. I added these three lines and everything worked like a charm! SetEnv ORACLE_HOME /path/to/oracle/home SetEnv ORA_NLS33 /path/to/oracle/home/ocommon/nls/admin/data SetEnv NLS_LANG AMERICAN Obviously, if your NLS_LANG is different, you should set it to whatever your NLS_LANG actually is. Ask your friendly DB admin for this information. Hope this helps someone who treads down the path that I just followed! Trent --was-- I spent several hours tracking down error ORA 24374, which would result from only *SOME* of my select statements. This error would be caused if I made a query that would return any non-numerical value. I am running an Apache 1.3.x webserver and PHP 4.2.1. The fix is to add entries in your httpd.conf file that would export your environment settings. I added these three lines and everything worked like a charm! SetEnv ORACLE_HOME /path/to/oracle/home SetEnv ORA_NLS33 /path/to/oracle/home/ocommon/nls/admin/data SetEnv NLS_LANG AMERICAN Obviously, if your NLS_LANG is different, you should set it to whatever your NLS_LANG actually is. Ask your friendly DB admin for this information. Hope this helps someone who treads down the path that I just followed! Trent http://php.net/manual/en/ref.oci8.php