#2300 [Csd->Bgs]: Can't select STRING (VARCHAR) values from the Oracle DB
| From: | tony2001@php.net | Date: | Mon, 17 Jul 2006 08:52:14 +0000 |
| Subject: | #2300 [Csd->Bgs]: Can't select STRING (VARCHAR) values from the Oracle DB | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-99518@lists.php.net to get a copy of this message | ||
ID: 2300
Updated by: tony2001@php.net
Reported By: admin at polad dot ru
-Status: Closed
+Status: Bogus
-Bug Type: Oracle related
+Bug Type: OCI8 related
Operating System: RedHat Linux 5.0 (kernel 2.0.38)
PHP Version: 3.0.12
Previous Comments:
------------------------------------------------------------------------
[1999-09-16 04:09:35] thies at cvs dot php dot net
Andrew said:
Sorry, the problem was in Oracle client.
------------------------------------------------------------------------
[1999-09-15 00:00:44] admin at polad dot ru
OCIResult normaly gets the number and date values but it doesn't get
varchar values.
$conn = OCILogon("polad_sys", "polad_sys", "POLAD5-TCP.world");
$sql = "select * from test";
$stat = OCIParse($conn, $sql);
OCIExecute($stat, OCI_DEFAULT);
while (OCIFetch($stat)) {
$ncols = OCINumCols($stat);
for ( $i = 1; $i <= $ncols; $i++ ) {
$result = OCIResult($stat, $i); /* !!!! */
print $result; /* using $result[1] I get the first char of the
string */
echo "<BR>";
}
echo "</TR>";
}
OCIFreeStatement($stat);
OCILogoff($conn);
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=2300&edit=1