Hi all,
Got a BIG problem when trying to use a php site with Oracle (the same thing
works perfectly with DB2-udb).
My config is :
NT4sp4
Apache 1.3.14
php4.0.4pl1 (Apache module)
Oracle 8.1.6
I try to determine the maximum value for a column, in this kind of script :
<?php
$Req='SELECT max(NUMEROSITE) FROM SITE';
$link = odbc_connect("FIDEX", 'fidex','fidex', SQL_CUR_USE_ODBC);
$Res_ID = odbc_exec($link,$Req);
Echo '<BR>Result ID='.$Res_ID;
$NF = odbc_num_fields($Res_ID);
Echo '<BR>Number of fields in result='.$NF;
$Cpt=1;
while(odbc_fetch_row($Res_ID)) {
echo '<br>err='.odbc_error();
$Resu[$Cpt] = odbc_result($Res_ID,1);
$Cpt++;
}
Echo "<br>Number of lines in result=".count($Resu);
for ($i=1; $i<=count($Resu); $i++) {
ECHO '<br>valeur="'.$Resu[$i].'"<br>';
}
$Res_ID = odbc_commit($link);
odbc_close($link);
?>
The table SITE contains several lines, and the current maximum NUMEROSITE
value is 10 (INTEGER column). If I try the request in the SQL*Plus
Worksheet, or using the Oracle ODBC Test, I have the correct answer: 1 line
saying "10".
If I execute the php script, the result is the following :
Result ID=Resource id #2
Number of fields in result=1
Number of lines in result=0
If I try to use another cursor parameter for my connect order, the result
is... Exception in Apache.exe "the memory couln't be written" !!!
In this case, the error seems to be generated by an endless loop
(odbc_fetch_row is always true, by there is no result)...
Any idea ?
TIA
--
FX Liagre
[EMAIL PROTECTED]
[EMAIL PROTECTED]
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
