#21491 [Fbk->Opn]: Hang during ociexecute

[stephan . rey]

 ID:   21491
 User updated by:  [EMAIL PROTECTED]
 Reported By:  [EMAIL PROTECTED]
-Status:   Feedback
+Status:   Open
 Bug Type: OCI8 related
 Operating System: Suse Linux 8.0
 PHP Version:  4.2.3
 New Comment:

Thanks champs!

The problem was the putenv()-statements. I've entered the definitions
for these variables right in front of the apache-start-script and know
it works great!


Previous Comments:


[2003-01-07 14:49:54] [EMAIL PROTECTED]

Does it help if you 'do it by the book',
, i.e. don't use putenv() or
Apache's SetEnv, but set the environment variables before you start
Apache? And did you check whether your Apache is linked to pthread (see
the page mentioned above)?



[2003-01-07 09:32:33] [EMAIL PROTECTED]

Works fine on Solaris in DSO and CGI.  You might want to test the
connection to see if it happened and call OCIError as well.



[2003-01-07 08:19:04] [EMAIL PROTECTED]

I'm trying to get some (existing) records oput of an Oracle8-Database.
As long as I do a query, which can't have any results, everything works
fine. But if I write a SELECT-statement, which should give at least one
result, the whole thing hangs or I get the message 'The page cannot be
displayed'.


example (which causes me troubles):




The 'echo-statement' is only used to verify that the script has
finished! The statement "select max(id_pers) from t_person" for example
works fine.

Thanks in advance!
Greetings
Stephan




-- 
Edit this bug report at http://bugs.php.net/?id=21491&edit=1

#21491 [NEW]: Hang during ociexecute

[stephan . rey]

From: [EMAIL PROTECTED]
Operating system: Suse Linux 8.0
PHP version:  4.2.3
PHP Bug Type: OCI8 related
Bug description:  Hang during ociexecute

I'm trying to get some (existing) records oput of an Oracle8-Database. As
long as I do a query, which can't have any results, everything works fine.
But if I write a SELECT-statement, which should give at least one result,
the whole thing hangs or I get the message 'The page cannot be
displayed'.


example (which causes me troubles):




The 'echo-statement' is only used to verify that the script has finished!
The statement "select max(id_pers) from t_person" for example works fine.

Thanks in advance!
Greetings
Stephan
-- 
Edit bug report at http://bugs.php.net/?id=21491&edit=1
-- 
Try a CVS snapshot: http://bugs.php.net/fix.php?id=21491&r=trysnapshot
Fixed in CVS:   http://bugs.php.net/fix.php?id=21491&r=fixedcvs
Fixed in release:   http://bugs.php.net/fix.php?id=21491&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=21491&r=needtrace
Try newer version:  http://bugs.php.net/fix.php?id=21491&r=oldversion
Not developer issue:http://bugs.php.net/fix.php?id=21491&r=support
Expected behavior:  http://bugs.php.net/fix.php?id=21491&r=notwrong
Not enough info:http://bugs.php.net/fix.php?id=21491&r=notenoughinfo
Submitted twice:http://bugs.php.net/fix.php?id=21491&r=submittedtwice
register_globals:   http://bugs.php.net/fix.php?id=21491&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=21491&r=php3
Daylight Savings:   http://bugs.php.net/fix.php?id=21491&r=dst
IIS Stability:  http://bugs.php.net/fix.php?id=21491&r=isapi
Install GNU Sed:http://bugs.php.net/fix.php?id=21491&r=gnused