Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sql = "begin some_procedure(:ID, :JSON);";
- try{
- $i=0; //ID
- $arr[$i]['name']='ID';
- $arr[$i]['val']=$id;
- $arr[$i]['len']=10;
- $i=0;
- $res[$i]['name']='JSON';
- $res[$i]['len']=1000;
- $res=db_call_func($sql, $arr, $res, $conn);
- var_dump($res["JSON"]);
- }catch(Exception $exc) {
- var_dump($exc->getMessage());
- }
- function db_call_func($sql,$arr=null,$res=null, $conn){
- $stmt = oci_parse($conn, $sql);
- foreach ($arr as $a){
- oci_bind_by_name($stmt, ":".$a['name'], $a['val'], $a['len']);
- }
- $resarr = [];
- foreach ($res as $r){
- oci_bind_by_name($stmt, ":".$r['name'], $resarr[$r['name']], $r['len']);
- }
- oci_execute($stmt);
- oci_commit($conn);
- $resarr['stmt']=$stmt;
- return $resarr;
- }
Add Comment
Please, Sign In to add comment