title: How to call a stored procedure in CodeIgniter?
body: <p>I can't call a stored procedure in CodeIgniter. However, when I call the procedure directly in MySQL, it works. Why isn't it working when I call it in CodeIgniter?</p>
  
  <pre><code>CREATE DEFINER=`root`@`localhost` PROCEDURE `test_proc`()
  LANGUAGE SQL
  NOT DETERMINISTIC
  CONTAINS SQL
  SQL SECURITY DEFINER
  COMMENT ''
  BEGIN
    declare name1 TEXT;
    declare id1 TEXT;
    select name,id into name1,id1 from my_tbl WHERE name='sam';
    select * from my_tbl;
    select name1,id1;
  END
  </code></pre>