Welcome Guest, Not a member yet? Register   Sign In
Execute Oracle procedure with one OUT parameter
#4

Just use regular OCI functions:

Code:
        $var1 = 1;
        $var2 = 1;
        $var3 = 0;
        $stmt = oci_parse($this->db->conn_id,
        "begin
            schema.procedure(:in1,:in2,:out1);
        end;");
        oci_bind_by_name($stmt, ':in1', $var1,-1,SQLT_INT);
        oci_bind_by_name($stmt, ':in2', $var2,-1,SQLT_INT);
        oci_bind_by_name($stmt, ':out1', $var3,99,SQLT_INT); // here you should enter max possible length of out parameter
        $r = oci_execute($stmt);                
        if ($r==true) {
            //use $var3 as return value of OUT parameter
        }
Reply


Messages In This Thread
RE: Execute Oracle procedure with one OUT parameter - by nortonex - 09-21-2017, 03:19 AM



Theme © iAndrew 2016 - Forum software by © MyBB