php3-script:
<?php $db = odbc_connect("tennisliste-ora", "stef", "stef"); ?>

$ortnr = 1;
$ort = odbc_prepare($db, "select beschreibung from ort where ortnr=$ortnr");
odbc_execute($ort);

$row = odbc_fetch_row($ort);

if ($row)
  echo "ort: $row";
else
  echo "fetch failed";

?>
---------------------
php3-configure-line:
./configure --with-shared-apache=/home/stef/apache --with-iodbc=/home/stef/iodbc/iodbc --with-mysql=/home/stef/mysql     
-----------------------
no alterations to any ini file, I run it as a module within apache 1.3.4
----------------------
The following setup is used:
Oracle Server under NT, with HotSockets ODBC Driver (middleware), I connect from he Linux via iODBC Driver Manager and HotSockets ODBC Driver.
The query above works 100% of the time when using a cmdline odbc test-tool, thru apache/php3 it fails 50-90% of the time, I couldn?t make out any relevant factors.
When using the same php3-script with the mysql database on the same machine, it works 100% as well.
My guess is that there are some quirks in the functions/unified_odbc.c - I already had to get rid of the trying to set dynamic cursors to get mysql to work.