Bug #1879 Updated: Document contains no data when doing Fetch /
| From: | sander@php.net | Date: | Sun, 16 Jun 2002 12:35:10 +0000 |
| Subject: | Bug #1879 Updated: Document contains no data when doing Fetch / | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-10647@lists.php.net to get a copy of this message | ||
ID: 1879
Updated by: sander@php.net
Reported By: smweb@ihost.de
-Status: Open
+Status: Bogus
Bug Type: Oracle related
Operating System: Linux
PHP Version: 3.0.11
New Comment:
Thank you for taking the time to report a problem with PHP.
Unfortunately, PHP 3 is no longer supported. Please download
the latest version of PHP 4 from http://www.php.net/downloads.php
If you are able to reproduce the bug with one of the latest
versions of PHP, please change the PHP version on this bug report
to the version you tested and change the status back to "Open".
Again, thank you for your continued support of PHP.
Previous Comments:
------------------------------------------------------------------------
[1999-07-26 11:08:02] smweb@ihost.de
Hi,
there seems to be a weird bug regarding OCIFetch(Into). Here's my PHP
script:
=== start
<html>
<head>
<title>PHP Test</title>
</head>
<body>
<TABLE CELLPADDING=5 BORDER=1>
<TR>
<TH>Alias</TH>
<TH>Full Name</TH>
</TR>
<?php
PutEnv("ORACLE_HOME=/usr/local/oracle");
PutEnv("ORACLE_SID=KIM");
$conn = OCILogon("web", "web", "KIM");
$stmt = OCIParse($conn, "select a, b from bla");
OCIExecute($stmt);
while (@OCIFetchInto($stmt, &$arrResult, OCI_ASSOC)) {
echo '<TR><TD>', $arrResult["A"],
'</TD><TD>', $arrResult["B"],
'</TD></TR>';
}
OCIFreeStatement($stmt);
OCILogOff($conn);
?>
</table>
<FORM ACTION="insert.php3" METHOD="post">
<TABLE><TR>
<TH>Alias:</TH><TD><INPUT TYPE="text" SIZE=20
NAME="alias"></TD></TR>
<TH>Fullname:</TH><TD><INPUT TYPE="text" SIZE=20
NAME="fullname"></TD></TR>
<TR><TD COLSPAN=2><INPUT TYPE="submit"
NAME="OK"></TD></TR>
</TABLE>
</form>
</body>
</html>
=== end
This is the result:
=== start
Content-type: text/html
<html>
<head>
<title>PHP Test</title>
</head>
<body>
<TABLE CELLPADDING=5 BORDER=1>
<TR>
<TH>Alias</TH>
<TH>Full Name</TH>
</TR>
Speicherzugriffsfehler
=== end
As soon as I comment this line
while (@OCIFetchInto($stmt, &$arrResult, OCI_ASSOC)) {
out, there's no error anymore.
I configured php using
./configure --with-oracle=/usr/local/oracle --enable-track-vars
(cgi version - the oracle dir is correct!)
The compilation worked without errors.
When I try to open the doc using Netscape, it says 'Document contains
no data.'
Thanks,
- Steffen
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=1879&edit=1