|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2002-02-11 10:07 UTC] maaj at mart dot nl
[2002-02-11 15:21 UTC] cnewbill@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sun Oct 26 18:00:01 2025 UTC |
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