oci8 set serveroutput

[jmurch]

Does anyone know of a way to do this? I am not getting any of my OUT parameters when calling a stored procedure thru OCI8.  Besides serveroutput is there anywhere else that may preventing my getting the OUT values?

 

<?

$c = oci_connect("jeffm", "welcome1", "10.2.1.25:1524/cdba");

 

$sql = 'BEGIN apps.sayHello(:name, :message); END;';

 

$stmt = oci_parse($conn,$sql);

 

//  Bind the input parameter

oci_bind_by_name($stmt,':name',$name,32);

 

// Bind the output parameter

oci_bind_by_name($stmt,':message',$message,32);

 

// Assign a value to the input

$name = 'Jeff';

 

oci_execute($stmt);

 

// $message is now populated with the output value

print "$message\n";

?>

[jmurch]

I am using the same connection to perform selects and it works fine...........

[Mark Baker]

$statement = $db->prepare("CALL " . $call."(".$inParams.",?)");
$statement->bindParam(1, $outParam, PDO::PARAM_STR, 32767);

$returnVal = $statement->execute();