"SELECT DISTINCT c.responsibility_name 
 FROM fnd_user a, fnd_user_resp_groups b, fnd_responsibility_tl c
 WHERE a.user_name = '".$_GET['username']."'
   AND b.user_id = a.user_id
   AND b.responsibility_id = c.responsibility_id
   AND (b.end_date is null or b.end_date > sysdate)
   AND b.start_date < sysdate";
//On execute la requête en lui passant l'option OCI_DEFAULT
ociexecute($stmt);
//On parcourt les résultats et on affiche les champs
while (ocifetch($stmt)) { 
	echo ociresult($stmt,1)."<br>"; 
} 

"UPDATE oracle SET droits=??? WHERE CONCAT(nom,' ',prenom)='".$_SESSION['id']."'"; 

while (ocifetch($stmt)) {
    $var =  ociresult($stmt,1);
   //ici tu fais la requete oracle d'update : "UPDATE oracle SET droits=".$var." WHERE CONCAT(nom,' ',prenom)='".$_SESSION['id']."'";
}

while (ocifetch($stmt)) {
   if (isset($var)) $var.= ociresult($stmt,1)."<br>";
   else $var = ociresult($stmt,1)."<br>";
}

   //ici tu fais la requete oracle d'update : "UPDATE oracle SET droits=".$var." WHERE CONCAT(nom,' ',prenom)='".$_SESSION['id']."'"; 

while (ocifetch($stmt)) { 
	$droits = ociresult($stmt,1)."<br>"; 

require_once('../../connections/reseau.php'); // permet d'avoir les informations de connection à la base
mysql_select_db("reseau") or die("Impossible de trouver la base");
$query = "UPDATE oracle SET droits='$droits' WHERE CONCAT(nom,' ',prenom)='".$_SESSION['id']."'"; 
$result = mysql_query($query);
}