Bug #18002: inserted value too large for column
| From: | qingping at hotmail dot com | Date: | Wed, 26 Jun 2002 20:16:01 +0000 |
| Subject: | Bug #18002: inserted value too large for column | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-12165@lists.php.net to get a copy of this message | ||
From: qingping@hotmail.com
Operating system: sun4u sparc SUNW,Ultra-5_10Syste
PHP version: 4.1.2
PHP Bug Type: OCI8 related
Bug description: inserted value too large for column
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 bug report at http://bugs.php.net/?id=18002&edit=1
--
Fixed in CVS: http://bugs.php.net/fix.php?id=18002&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=18002&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=18002&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=18002&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=18002&r=support
Expected behavior: http://bugs.php.net/fix.php?id=18002&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=18002&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=18002&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=18002&r=globals