Pear DB - Oracle - Problem with strings bigger than 4K
| From: | Alf Magne Kalleland | Date: | Thu, 20 Feb 2003 17:49:21 +0000 |
| Subject: | Pear DB - Oracle - Problem with strings bigger than 4K | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-3871@lists.php.net to get a copy of this message | ||
While using pear, I get this error-message:
ORA-01704: string literal too long
while trying to insert a string into the database(Oracle 9)
Here's a code-example:
$sql = "insert into myTable(ID,myName,textField)values('1000','Alf
Magne','<Text bigger than 4K>')";
$result = $db->query($sql);
// Always check that $result is not an error
if (DB::isError($result)) {
die ($result->getMessage());
}
where <Text bigger than 4K> is a long string.
Please help!
Regards
Alf Magne Kalleland