returning record set from stored procedure in codeigniter

[eluser]Unknown[/eluser]
How do I go about using php activerecord to return a single row from the stored procedure?

I hope it is possible in code igniter. Thanks in advance