#37139 [Fbk->Opn]: OCIExecute() hangs on DATE column related INSERT's

ID: 37139 User updated by: aphexddb at gmail dot com Reported By: aphexddb at gmail dot com -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: Windows XP SP2 PHP Version: 5.1.3RC2 New Comment: Turns out if you have too many open cursors (more then the curent Oracle pool allows) this will happen. Increased it and PHP was just fine. Previous Comments: ------------------------------------------------------------------------ [2006-04-19 21:34:08] tony2001@php.net Can't reproduce in any combination I can try here: native client + Oracle 9, OIC + Oracle 9, OIC + Oracle 10. Snapshots and the debugpack are located here temporarily: http://php.emini.dk/snaps/win32/ Please try the latest snapshot and provide the backtrace if you're still able to reproduce it. ------------------------------------------------------------------------ [2006-04-19 21:10:30] aphexddb at gmail dot com Description: ------------ When executing a succesfully prepared INSERT statement that contains a DATE column, OCIExecute hangs indefinitely when data is supplied for that column. I tested the SQL statement(s) in question by pasting them into both TOAD and SQLPlus. They all completed successfully. The '$workingSQL' statement executes correctly from PHP. The other '$breaksPhp' statements will hang right as OCIExecute() is called. PHP Version used: Apache/2.0.54 (Win32) PHP/5.1.3-dev. Also tried PHP versions : 5.0.3 and 5.1.2 for grins. http://snaps.php.net seems to be down at the time of this posting, unable to run the debug pack. Diffrences in PHP.INI from the .dist file: error_reporting = E_ALL extension=php_gd2.dll extension=php_ldap.dll extension=php_mysql.dll extension=php_oci8.dll extension=php_oracle.dll extension=php_sockets.dll extension=php_xmlrpc.dll extension=php_xsl.dll extension=php_soap.dll extension=adodb.dll SMTP = mail.mydomain.com Reproduce code: --------------- $sql = "INSERT blah, blah ...see below" $stmt = OCIParse($this->_connectionID, $workingSQL); $rs = OCIExecute($stmt); <...browser/php hangs here...> The table in question: CREATE TABLE PROVIDER ( PROVIDER_ID NUMBER NOT NULL, SITE_NAME VARCHAR2 (50), FIRST_NAME VARCHAR2 (20), LAST_MOD_USER VARCHAR2 (20), LAST_MOD_DATE DATE NOT NULL, CONSTRAINT PROVIDER_PK PRIMARY KEY ( PROVIDER_ID ) ) ; Example SQL statements: $workingSQL = "INSERT INTO PROVIDER ( PROVIDER_ID, SITE_NAME, FIRST_NAME, LAST_MOD_USER ) VALUES ( '351', 'Site Name', 'John', 'jsmith') "; $breaksPhpSQL = "INSERT INTO PROVIDER ( PROVIDER_ID, SITE_NAME, FIRST_NAME, LAST_MOD_USER, LAST_MOD_DATE ) VALUES ( '351', 'Site Name', 'John', 'jsmith', '2006-04-19' ) "; $breaksPhpSQL2 = "INSERT INTO PROVIDER ( PROVIDER_ID, SITE_NAME, FIRST_NAME, LAST_MOD_USER, LAST_MOD_DATE ) VALUES ( '351', 'Site Name', 'John', 'jsmith', TO_DATE('2006-04-19','RR-MM-DD') ) "; Expected result: ---------------- OCIExecute() should complete without hanging and return a result. Actual result: -------------- PHP hangs indefinitely for whatever page you were looking at. In other browser windows while the main one is hung, PHP will still render other, simpler pages but anything using OCI is unavailable. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=37139&edit=1