Oracle Procedure

[mattclements]

<?php
if ($c = oci_connect("****","****", "****")) {
   echo "Successfully connected to Oracle";
   //oci_close($c);
} else {
   $err = oci_error();
   echo "Oracle Connect Error " . $err['text'];
}
  
$stmt="BEGIN display_msg(_login_id, _date, _msg); END;"
    //$stmt="	SELECT *
//			FROM display_msg";

//if (oci_num_rows($stmt) == 0) {
//	echo '<meta http-equiv="refresh" content="0;url=changeclub.php" />';
//}

    $qres=oci_parse($c,$stmt);
oci_bind_by_name($qres, "_login_id", $slogin);
oci_bind_by_name($qres, "_date", 'sysdate');
oci_bind_by_name($qres, "_msg", $message, 32);

    oci_execute($qres);

//while (oci_fetch($qres)) {
//	echo oci_result($qres, "msg_meaning") ."<br /><hr /><br />\n";
//}

echo $message;

    oci_commit($c);
?>

 

The oci_bind_by_name is causing a blank screen! So stuck as to why this is happening.

 

Regards,

Matt

[Maq]

Sorry, I'm not too familiar with PHP and ORACLE but you can put these lines directly after your opening <?php tags to display errors.

 

ini_set ("display_errors", "1");
error_reporting(E_ALL);

[mattclements]

Hello,

This still leaves a blank page with no errors.

 

Regards,

Matt