How to get return value from procedure in CodeIgniter?

Question

CodeIgniter

There is a procedure that returns a number when executed.
In CI I'm trying to get the value like this:

$str ="DECLARE	@ret int ".
"exec @ret = [my_proc] ".
"@UserID = '".$this->getID()."', ". 
"SELECT	'val' = @ret"; 
$result = $this->db->query($str); 
return    $result->result('val');

as a result, return returns an empty value because $result is null
However, if you just run it in ssms, everything works OK, it returns 1 column with 1 row with the value I need.

Answer 1

look at the row method
call it like this $result->row('val')

Answer 2

There is some error in the request that is sent to the server.
Look at the query that was formed in the line.
Try it without codeigniter.