I'm trying to get some (existing) records oput of an Oracle8-Database. As long as I do a query, which can't have any results, everything works fine. But if I write a SELECT-statement, which should give at least one result, the whole thing hangs or I get the message 'The page cannot be displayed'.


example (which causes me troubles):

<?php
putenv('ORACLE_HOME=/opt/oracle/OraHome1');         
putenv('TNS_ADMIN=/opt/oracle/OraHome1/network/admin');         
putenv('TWO_TASK=/opt/oracle/OraHome1/network/admin/tnsnames.ora');
$user="";
$pwd="";
$conn = ocilogon($user,$pwd,"TNEUN2");
$sql="select * from t_person WHERE name like 'Muster' ORDER BY name, firstname, notes, racf";
$stmt=ociparse($conn,$sql);
ociexecute($stmt);
echo $sql;
?>


The 'echo-statement' is only used to verify that the script has finished! The statement "select max(id_pers) from t_person" for example works fine.

Thanks in advance!
Greetings
Stephan