$hDB = _OracleConnect();
$hStatement = $hDB->prepare("MY SQL");
$hStatement->execute( $var1, $var2, $var3 );
while ( ( $ret1, $ret2, $ret3 ) = $hStatement->fetchrow_array ){
  # do stuff
}
$hStatement->finish;
$hDB->disconnect;