ID: 25818 User updated by: iolaire dot mckinnon at vcint dot com Reported By: iolaire dot mckinnon at vcint dot com Status: Open Bug Type: OCI8 related Operating System: RedHat Linux 9 PHP Version: 4.3.3 New Comment:
I'm using a view. PHP is linked against the latest Oracle (9r2). I'm talking with Oracle now to see what they find. Previous Comments: ------------------------------------------------------------------------ [2003-10-17 03:00:19] cjbj at hotmail dot com ORA-03120 has sometimes been seen with cross-version or cross-platform Oracle connections. I think it might also have been seen in some obscure case when the characters sets differed on the client and server. Are you using a view or a dblink? Have you relinked PHP with your most recent Oracle client libraries? Maybe if you gave the Oracle version(s) and the datatype of the EMAIL column someone else might be able to identify what it happening. The comments in http://bugs.php.net/bug.php?id=19304 about contacting Oracle Support and checking Metalink are good suggestions. ------------------------------------------------------------------------ [2003-10-10 12:57:34] iolaire dot mckinnon at vcint dot com Yes, the database is running on Solaris 8. As mentioned, there's no problem with standard oracle, only OCI8. ------------------------------------------------------------------------ [2003-10-10 11:46:23] [EMAIL PROTECTED] See bug #19304. Is the remote oracle running on Solaris perhaps? ------------------------------------------------------------------------ [2003-10-10 08:17:04] iolaire dot mckinnon at vcint dot com I have the variables I'm putenv()ing there in SetEnv (httpd.conf) and export (.bash_profile) as well. It hasn't made a difference. The oracle is not running locally therefore the other comments regarding shared oracle/httpd groups don't appear to apply in this case. I compiled against Oracle 9r2. ------------------------------------------------------------------------ [2003-10-10 06:57:03] [EMAIL PROTECTED] Setting those environment variables in script is not gonna work, they need to be set BEFORE apache/php is started. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/25818 -- Edit this bug report at http://bugs.php.net/?id=25818&edit=1
