Stored Procedures in Codeigniter

[eluser]bleu[/eluser]
Can I know what is the right way to use stored procedures in codeigniter

I have tried certain ways of using stored procedures but they don't seem to work

I have a stored procedure as spgetname which takes one value.

How will I use this in Codeigniter?