[PHP-DEV] Bug #1276 Updated: OCIBindByName with DATE variable -> error From: Bug Database (php-dev <email protected>)
Date: 04/06/99

ID: 1276
Updated by: thies
Reported By: steffenmail <email protected>
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 <email protected>
For help: php-dev-help <email protected>