How to call stored procedure

[sierra]

Please suggest how can I call a stored procedure in a custom module

$res = $this->db->query(stockstatus(‘text’));

But this shows error as: Call to undefined function stockstatus()

Thanks