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.