PHP 4.0 Bug #5939: Use of an Oracle DB with ODBC functions
| From: | cedric_carbier at mail dot dotcom dot fr | Date: | Thu, 03 Aug 2000 08:57:35 +0000 |
| Subject: | PHP 4.0 Bug #5939: Use of an Oracle DB with ODBC functions | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-27518@lists.php.net to get a copy of this message | ||
From: cedric_carbier@mail.dotcom.fr
Operating system: Win NT 4.0
PHP version: Earlier? Upgrade first!
PHP Bug Type: ODBC related
Bug description: Use of an Oracle DB with ODBC functions
Hi everybody,
When I try to access an Oracle DB with the ODBC functions (a simple SELECT request...), I do get the
result that I want but my Web browser keeps on looking for something.
Furthermore, the PHP.EXE process on my Web server keeps on running (that is, after 5 or 6 requests,
the server gets out of memory and I must kill these processes myself...)
Here is a little piece of my program...
$connectionID = odbc_connect("PEGASE", "pub", "pub");
$resultID = odbc_exec($connectionID, "select * from edv.item_master where part_number like
'" .
$partNr . "'");
$count=0;
while($temp = odbc_fetch_into($resultID,&$tempArray)){
$count++;
}
$designation = $tempArray[16];
$ref = $tempArray[34];
odbc_close($connectionID);
Cheers,
Cedric