Calling stored procedure from codeigniter not working
<p>I'm using mysql as my db. I called a stored procedure from my model. following is my model function.</p>

<pre><code>public function call_sp()
    {
        $query = $this-&gt;db-&gt;query("call SPInsertEventTran()");
        return $query-&gt;result();
     }
</code></pre>

<p>My stored procedure is as follows.</p>

<pre><code>DELIMITER $$

CREATE DEFINER=`root`@`localhost` PROCEDURE `SPInsertEventTran`(
IN IN_event_name varchar(45),
IN IN_date date,
IN IN_place varchar(45),
IN IN_starting_time time,
IN IN_end_time time,
IN IN_no_of_cams int,
IN IN_booked_or_not varchar(45),
IN IN_customer_id int,
IN IN_package_id int


)
BEGIN

iNSERT iNTO   event(event_name,date,place,starting_time,end_time,no_of_cams,booked_or_not,customer_id,package_id)
        values   (IN_Event_Name,IN_place,IN_starting_time,IN_end_time,IN_no_of_cams,IN_booked_or_not,
            IN_customer_id,IN_package_id);

insert into quotation (camera_charges,other,discount,event_id)
    select ev.no_of_cams*pg.charge_per_cam ,null,null,ev.id
     from event ev
    inner join package pg on ev.package_id=pg.id
    where ev.id=(select max(id) from event);
END
</code></pre>

<p>I get an error like this.</p>

<pre><code>Error Number: 1318
Incorrect number of arguments for PROCEDURE mydb.SPInsertEventTran; expected 9, got 0
call SPInsertEventTran()
Filename: F:\wamp\www\eventmanagementsystem\system\database\DB_driver.php
Line Number: 331
</code></pre>

<p>Can anyone help me to fix the error?</p>