#37139 [NEW]: OCIExecute() hangs on DATE column related INSERT's

From: aphexddb at gmail dot com Operating system: Windows XP SP2 PHP version: 5.1.3RC2 PHP Bug Type: OCI8 related Bug description: OCIExecute() hangs on DATE column related INSERT's 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 bug report at http://bugs.php.net/?id=37139&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=37139&r=trysnapshot44 Try a CVS snapshot (PHP 5.1): http://bugs.php.net/fix.php?id=37139&r=trysnapshot51 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=37139&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=37139&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=37139&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=37139&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=37139&r=needscript Try newer version: http://bugs.php.net/fix.php?id=37139&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=37139&r=support Expected behavior: http://bugs.php.net/fix.php?id=37139&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=37139&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=37139&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=37139&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=37139&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=37139&r=dst IIS Stability: http://bugs.php.net/fix.php?id=37139&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=37139&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=37139&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=37139&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=37139&r=mysqlcfg