What I am trying to do is :
I have inline sql in the java code,so we want to move these sql to store proc for better performance.
Instead of inline sql we will call store proc but problem is I am not sure how I can retrieve data from the storeproc, right now it is executing the sql and returning the result set.
So please let me know if we convert below sql to store proc and call the storeproc , how we can retrieve the resultset? I am not sure if it is possible.
Please advice, urgent.