Bug #18002: inserted value too large for column

From: 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

« previous php.bugs (#12165) next »