How to know if stored procedure is successful in codeigniter?

[eluser]bleu[/eluser]
How to know if stored procedure is successful in codeigniter?

I am running my stored procedure like

Code:

$query= $this->db->query('call procedure(dsds)');

$query does not return 1 and affected_rows returns -1

[eluser]vitoco[/eluser]
my solution was create a 'sp_log' table to log the SP internal results with inserts, then read it from CI.