Bug #14385 Updated: unable to show clobs
| From: | maaj at mart dot nl | Date: | Mon, 11 Feb 2002 15:07:49 +0000 |
| Subject: | Bug #14385 Updated: unable to show clobs | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-133@lists.php.net to get a copy of this message | ||
ID: 14385
Updated by: maaj@mart.nl
Reported By: maaj@mart.nl
-Status: Open
+Status: Closed
Bug Type: OCI8 related
Operating System: hp-ux
PHP Version: 4.0.6
Previous Comments:
------------------------------------------------------------------------
[2002-02-11 10:07:35] maaj@mart.nl
The problem was caused by a different version of oracle client and the
server.
------------------------------------------------------------------------
[2001-12-08 10:58:47] maaj@mart.nl
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 this bug report at http://bugs.php.net/?id=14385&edit=1