Bug #10455: The method fetchRow can't return NULL when no more data.
| From: | nhitso at mail dot nhicb dot gov dot tw | Date: | Mon, 23 Apr 2001 11:22:38 +0000 |
| Subject: | Bug #10455: The method fetchRow can't return NULL when no more data. | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-52186@lists.php.net to get a copy of this message | ||
From: nhitso@mail.nhicb.gov.tw
Operating system: Linux 2.2.14-6.0lp
PHP version: 4.0.4pl1
PHP Bug Type: OCI8 related
Bug description: The method fetchRow can't return NULL when no more data.
<?php
$DSN="oci8://scott:gods";
require_once("DB.php");
$myDB = new DB;
$myOBJ = $myDB -> connect($DSN);
if ($myDB -> isError($myOBJ))
{ echo $myOBJ;
return NULL;
}
$resultOBJ = $myOBJ -> query("select * from addr_id");
if ($myDB -> isError($resultOBJ))
{ echo $resultOBJ;
return NULL;
}
else
{
while( $row = $resultOBJ->fetchRow() )
{ echo "$row[0] $row[1] $row[2] $row[3] $row[4] $row[5] $row[6] $row[7]\n"
;
}
}
?>
The result:
0 1234 2313 1233 RD. 68¸¹ R.O.C. TAIWAN
Warning: OCIFetchInto: ORA-01002: Â^¨úªº¶¶§Ç¤£¹ï in DB/oci8.php on line 206
Warning: OCIFetchInto: ORA-01002: Â^¨úªº¶¶§Ç¤£¹ï in DB/oci8.php on line 206
Warning: OCIFetchInto: ORA-01002: Â^¨úªº¶¶§Ç¤£¹ï in DB/oci8.php on line 206
--
Edit Bug report at: http://bugs.php.net/?id=10455&edit=1