How to retrive Last inserted id ?

[eluser]Rahul gamit[/eluser]
$this->db->insert_id() gives the id when i am using $this->db->insert() function,
but when i am using stored procedure for inserting the data the $this->db->insert_id() gives 0 as output.