Bug #1276 Updated: OCIBindByName with DATE variable -> error

ID: 1276 Updated by: thies Reported By: steffenmail@writeme.com Status: Closed Bug Type: Oracle related Assigned To: thies Comments: works for me -> try this code.... you should be able to insert empty columns using bound variables like shown below: <?php $conn = OCILogon("scott","tiger"); $stmt = OCIParse($conn,"insert into emp (empno, ename) ". "values (:empno,:ename) "); $data = array(1111 => "", 2222 => "Bill", 3333 => "Jim"); // "1111" has no user-name.... OCIBindByName($stmt,":empno",&$empno,10); OCIBindByName($stmt,":ename",&$ename,6); while (list($empno,$ename) = each($data)) { OCIExecute($stmt); OCIFreeStatement($stmt); OCILogoff($conn); ?> Full Bug description available at: http://bugs.php.net?id=1276 -- PHP Development Mailing List http://www.php.net/ To unsubscribe send an empty message to php-dev-unsubscribe@lists.php.net For help: php-dev-help@lists.php.net