Bug #18002 Updated: inserted value too large for column
| From: | qingping at hotmail dot com | Date: | Wed, 26 Jun 2002 22:28:31 +0000 |
| Subject: | Bug #18002 Updated: inserted value too large for column | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-12170@lists.php.net to get a copy of this message | ||
ID: 18002
Updated by: qingping@hotmail.com
Reported By: qingping@hotmail.com
-Status: Open
+Status: Closed
Bug Type: OCI8 related
Operating System: sun4u sparc SUNW,Ultra-5_10Syste
PHP Version: 4.1.2
New Comment:
Problem solved
Previous Comments:
------------------------------------------------------------------------
[2002-06-26 16:16:00] qingping@hotmail.com
when insert a lot of rows, sometimes got error, and found
not really the value is too large for the column:
2 OCIStmtExecute: ORA-01401: inserted value too large for column
/usr/local/lib/php/DB/oci8.php 149 Array
-----------------------------------------
$sql = "insert into Emails(email, URL, Status, createdDt)";
$sql .= "values
('$email','$URL','$status','$date')";
$res = $db->query($sql);
if (DB::isError($res) ){
die($res->getMessage());
}
$result = $db->commit();
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=18002&edit=1