Calling Stored Procedure on Codeigniter

[eluser]Unknown[/eluser]
I just want to know because I'm developing a online shopping cart.
I would like to know your opinion because I'm thinking of better approach.

Is it better to create a stored procedure containing the business process and just call it using codeigniter or just embed the sql syntax to codeigniter?

Thanks in advance...