Problem reading clob-data with php/pdo
608269Nov 13 2007 — edited Nov 14 2007Hi @all,
i'm working on a script which querys a table with clobs. Everything is working fine. But while reading from clob resource with stream_get_line the data is truncated after 16kb. Has anyone an idea?
Script ist running on Windows Server with Apache 2.2.4, PHP Version 5.2.4 and Oracle Express 10g.
Short example
<?php
try {
$db = new PDO('oci:host=localhost;', 'php', 'php', array(PDO::ERRMODE_EXCEPTION => true));
} catch (PDOException $e) {
die("getConnection: " .$e->getMessage());
}
$rs = $db->query("SELECT MOVIEDATA FROM movie WHERE ID = 682");
$row = $rs->fetch(PDO::FETCH_ASSOC);
$data = stream_get_line($row["MOVIEDATA"],100000);
?>