I am writing a web application using oracle sequal sql. I am trying to get a page working that will let the user insert three records into my database application. I created a procedure called "insertStudent" to insert the three items, student number, first name and lastname. I tested the stored procedure and it works fine and executes fine when I try using it in the oracle sql*plus command line window. I want it to work with the webpage a created letting the user click a button to make php push the info to my database. It wont work and I am not sure why. If you could show the solution and explain how you got it to work, I will upvote good response. Please test to maks sure it works if you can. Thanks

Student Number: First Name: Last Name:

# $conn = oci_connect('username', 'password', 'csci242'); $connect = oci_connect('username', 'password', 'csci242'); if (isset($_POST["insert_btn"])) {

$sql = "CALL insertStudent('".$_POST["HTML_StudentNumber"]."', '".$_POST["tStudentfName"]."', '".$_POST["tStudentlName"]."')"; if (oci_query($connect, $sql)) { header("location:index.php?inserted=1"); } } if (isset($_GET["inserted"])) { echo ''; }

?>