note 21901 added to ref.oci8

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://www.php.net/manual/en/ref.oci8.php http://master.php.net/manage/user-notes.php?action=edit+21901 http://master.php.net/manage/user-notes.php?action=delete+21901 http://master.php.net/manage/user-notes.php?action=reject+21901