how to call stored procedure using codeigniter?

Question

How to call stored procedure using codeigniter ? help me, please

function ViewSchedule($dt_dari,$dt_to,$dt_org,$dt_emp){
        $result = $this->db->query("exec dailyAttdCrossTab '".$dt_dari."','".$dt_to."','".$dt_org."','".$dt_emp."'");

        return $result;
    }

Answer 1

you can call stored procedure as below

$this->db->query("call test_proc()");