For one of my project, I'm thinking to use Stored Procedure (Of-course I will be using MySQL 5+ database). Before I get started, I'm curious if we can implement Stored Procedures at database end and then call it in our application (Most probably custom component).
I know, we will surely get a portability issue. But my client is not worrying about it as they always like to keep themselves up-to-date with latest technology.
If it is possible then, do we have helper functions in Joomla Framework to call SP (Stored Procedure). I tried to search it on internet, but looks like we do not have enough information on the same.