From: [EMAIL PROTECTED]
Operating system: hp-ux
PHP version: 4.0.6
PHP Bug Type: OCI8 related
Bug description: unable to show clobs
I've made a php website that communicates with an Oracle database. The
website reads and writes in Clob fields. On my server with php4.0.4pl1,
Oracle server and oracle client 8.0.4 everything goes well.
But when I try to run the website on my new server (php version 4.0.6, and
version 8.0.6 of oracle client, Oracle server stays at the same server).
I'm not able to read clob fields. But I am able to write in them. When I
try to get data from clob fields, I get an empty string.
I think the version of oracle client creates the problem. But I don't have
a clue how to solve this problem.
function that has the problem:
function clsReleaseNote($id) {
if ($id) {
$connection = ocilogon("test", "test", "db.server");
$query = "SELECT I.relid, I.commercialtxt, I.techtxt, I.testtxt,
I.reference, TO_DATE(I.RELDATE,'dd-mm-yyyy'), F.relpos, F.filename,
F.fileversion, F.filetype, F.relmainid FROM RELEASEINFO I, RELEASEFILES F
WHERE (I.RELID = F.RELID) AND (F.RELID = " . $id . ") ORDER BY F.RELPOS
ASC";
$stmt = OCIParse($connection, $query);
OCIExecute($stmt);
for($i=0;OCIFetchInto ($stmt, &$row
,OCI_RETURN_LOBS+OCI_RETURN_NULLS);$i++) {
if($i==0) {
$this->Id = rtrim($row[0]);
$this->Reference = rtrim($row[4]);
$this->Date = rtrim($row[5]);
$this->Commercial = $row[1];
$this->Technical = $row[2];
$this->Test = $row[3];
}
$this->Files[rtrim($row[6])] = array
(
"POS" => rtrim($row[6]),
"NAME" => rtrim($row[7]),
"VERSION" => rtrim($row[8]),
"TYPE" => rtrim($row[9]),
"RELEASE" => rtrim($row[10])
);
}
if($i == 0) {
ShowError("Niet gevonden","Deze releasenote is niet
in de database gevonden");
}
}
}
modules php was compiled with: oci8, without-mysql
--
Edit bug report at: http://bugs.php.net/?id=14385&edit=1
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
