#36764 [Opn->Fbk]: pdo_oci hangs apache

ID: 36764 Updated by: tony2001@php.net Reported By: mauroi at digbang dot com -Status: Open +Status: Feedback Bug Type: PDO related Operating System: Win XP SP2 PHP Version: 5CVS-2006-03-16 (snap) New Comment: Thank you for this bug report. To properly diagnose the problem, we need a backtrace to see what is happening behind the scenes. To find out how to generate a backtrace, please read http://bugs.php.net/bugs-generating-backtrace.php for *NIX and http://bugs.php.net/bugs-generating-backtrace-win32.php for Win32 Once you have generated a backtrace, please submit it to this bug report and change the status back to "Open". Thank you for helping us make PHP better. All I get is: array(2) { ["FIELD"]=> string(4) "1.0E" [0]=> string(4) "1.0E" } (I did "insert into foo values (1)") Previous Comments: ------------------------------------------------------------------------ [2006-03-18 20:54:55] mauroi at digbang dot com I'm using oracle instant client (on windows), and oracle 10R2 on linux also. I tried this script on linux (centos4, same machine): $conn = new PDO('oci:dbname= :o)', 'user', 'pass'); $a = $conn->prepare('SELECT * FROM foo'); var_dump($a->execute()); echo 'aa'; var_dump($a->fetch()); echo 'bb'; and got this: "bool(true) aa" (row information and bb missing) I don't get anything wrong in the error_log. Just the usual line in the access_log. Did you insert data on the table? With an empty table it doesn't happen. Thank you. ------------------------------------------------------------------------ [2006-03-18 20:31:23] tony2001@php.net I'm afraid "The page keeps loading forever" and "hangs" is not enough to understand the problem and I can't reproduce it on Linux with Oracle Instant Client and Oracle 10. What version of Oracle client and server are you using? What's in the error_log? Any other info? ------------------------------------------------------------------------ [2006-03-17 13:55:43] mauroi at digbang dot com Yes. The same happens. The page keeps loading forever. ------------------------------------------------------------------------ [2006-03-17 09:22:15] tony2001@php.net Please try using this CVS snapshot: http://snaps.php.net/php5.1-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.1-win32-latest.zip Sure I did a mistake. ------------------------------------------------------------------------ [2006-03-16 22:45:07] mauroi at digbang dot com The supplied link is for php4. I think you made a mistake. Tell me if i'm wrong. Thanks. ------------------------------------------------------------------------ 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/36764 -- Edit this bug report at http://bugs.php.net/?id=36764&edit=1