Hello everyone--
I know this topic has been hit on before here but from what I found it doesn't really help me too much. What I have is a stored procedure that adds information to a database and returns a CODE and a MSG telling the user if the procedure has worked or not. Here's a bit of my code that doesn't work 🙂 Any and all help is very appreciated!! 🙂
$conn = OCILogon("connect stuff here");
$curs = OCINewCursor($conn);
$p_acct_no = 1160000001;
$p_div = 116;
$p_CDE_ACTION = "Order";
$p_name = "Php Test";
$p_PHONE_NO = 6914417;
$p_PHONE_TYPE = "PHONE";
$p_login_id = "WEB";
$p_contact_id = "";
$p_commit = "Y";
$stmt = OCIParse($conn,"begin :return_value := NAC_CONTACT_ADD(:p_acct_no, :p_div, :p_CDE_ACTION, :p_name, :p_PHONE_NO, :p_PHONE_TYPE, :p_login_id, :p_contact_id, :p_commit); end;");
ocibindbyname($stmt,"return_value",&$retval,-1);
ocibindbyname($stmt,"p_acct_no",&$p_acct_no,-1);
ocibindbyname($stmt,"p_div",&$p_div,-1);
ocibindbyname($stmt,"p_CDE_ACTION",&$p_CDE_ACTION,-1);
ocibindbyname($stmt,"p_name",&$p_name,-1);
ocibindbyname($stmt,"p_PHONE_NO",&$p_PHONE_NO,-1);
ocibindbyname($stmt,"p_PHONE_TYPE",&$p_PHONE_TYPE,-1);
ocibindbyname($stmt,"p_login_id",&$p_login_id,-1);
ocibindbyname($stmt,"p_contact_id",&$p_contact_id,-1);
ocibindbyname($stmt,"p_commit",&$p_commit,-1);
OCIExecute($stmt);
OCIFreeStatement($stmt);
OCILogoff($conn);
