Can't reproduce. Please include short scripts and instructions how to reproduce this.

--Jani

I tryed to reproduce this and here is the script.

I run 2 different SQL statements. First one is wrong (contains invalid table name) and second is correct. If there is an error in SQL statement script is terminated using die(). 

On next page hit after execution of wrong SQL statement i'm getting: 

[notice] child pid 7358 exit signal Segmentation fault (11)

in Apache error_log file and mess in defined constants. 

In the original script there is no wrong SQL statements but somehow i'm getting same result. Obviously the problem is in OCI8 extention not in HTTP redirections.

There is no problems running same script on PHP 4.0.4pl1.

<?php
define("CONSTANT",		"value");
define("MAX_REDIRECTS", 10);

define("LOGIN", 		"scott");
define("PASSWORD", 		"tiger");
define("DB", 			"oracle");

if (CONSTANT != "value") die($hitNo." failed."."<br> <a href='".$SCRIPT_NAME."?hitNo=".$hitNo."'>Click to continue.</a><br>");

$sql[0] = "select * from session_Log where userID=1";
$sql[1] = "select * from sessionLog where userID=1";

$hitNo = $hitNo ? $hitNo+1 : 1;

function ociSelect(&$data) {
	global $sql, $hitNo, $SCRIPT_NAME;
	$conn = ociNLogon(LOGIN, PASSWORD, DB);
	
	if ($stmt = ociParse($conn, $sql[$hitNo % 2])) {
		if (!@ociExecute($stmt,OCI_DEFAULT)) {
			$error = ociError($stmt);
			die($error["message"]."<br> <a href='".$SCRIPT_NAME."?hitNo=".$hitNo."'>Click to continue.</a><br>");
		}
		$nrows = ociFetchStatement($stmt, $data);
		ociFreeStatement($stmt);
	} else die("Cannot parse SQL statement.");
	
	ociCommit($conn);
	ociLogoff($conn);
}

ociSelect($data);
if ($hitNo < MAX_REDIRECTS) {
	header("Location: ".$SCRIPT_NAME."?hitNo=".$hitNo);
	exit;
} else echo $hitNo." HTTP redirects passed ok.<br> <a href='".$SCRIPT_NAME."'>Click to test it again.</a><br>";
?>

If script is executed on PHP 4.0.4pl1 there is  warning in Apache errof_log file:

Warning:  failed to rollback outstanding transactions!: ORA-24324: service handle not initialized 

reclassified to an OCI bug, as that is what this is...updated Short Desc as well...

this should be fixed some time ago. try  PHP >= 4.1