Codeigniter DB errors after stored procedure call

Question

I have a database that has a few stored procedures in it that I would like to call via CodeIgniter. I have the following code in my Model class:

$sql = "CALL `stored_proc`(1)";
$query = $this->db->query($sql); //This call breaks the DB :(

$this->db->select('status');
$this->db->where('id', $id);
$query = $this->db->get('table');

print($query->num_rows()); //line 1116

When I run this code, I get the following error:

Fatal error: Call to a member function num_rows() on a non-object in C:\server\apache\htdocs\application\models\let_model.php on line 1116

If I remove the query line, the select works properly. Also, if I replace the call to a stored procedure with say a SELECT command, it also works properly.

Is there something obvious I'm missing for why I'm getting this error? If there isn't a good answer, is there a way to work around this problem?

Thanks for your time!

Edit: After delving a little deeper into the problem, it seems that this error will occur if my stored procedure contains a SELECT command. UPDATES seem to work properly. Perhaps this problem has something to do with how CodeIgniter deals with SELECT results?

eric.itzhak · Accepted Answer · 2013-02-10 11:15:12Z

1

Since this question appears first on google, i've managed to solve this by using :

$this->db->simple_query($query);

Instead of the regular query function.

answered Feb 10, 2013 at 11:15

eric.itzhak

16.2k28 gold badges96 silver badges147 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

KLee1 · Accepted Answer · 2012-09-19 01:26:47Z

0

The problem was that the SELECTs in the stored procedure were causing problems in CodeIgniter. By making sure that all of the SELECTs were directed (i.e. with the INTO clause), the stored procedure was able to run successfully.

For example,

-- This causes an error in CodeIgniter when inside a stored procedure.
SELECT GET_LOCK('lock1',0);  

-- This does not.
DECLARE _lock_result INT;
SELECT GET_LOCK('lock1',0) INTO _lock_result;

I am still unaware of the underlying causes of why this causes an error, but this solution will suffice for my current work.

answered Sep 19, 2012 at 1:26

KLee1

6,1984 gold badges32 silver badges42 bronze badges

Comments

Nishant Jani · Accepted Answer · 2012-09-19 08:33:36Z

0

use only

$query->num_rows instead of $query->num_rows()

answered Sep 19, 2012 at 8:33

Nishant Jani

1,9918 gold badges30 silver badges41 bronze badges

Collectives™ on Stack Overflow

Codeigniter DB errors after stored procedure call

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related