Ofcourse RefCursor needs to be opened for the SELECT statement. As I had mentioned, reporting.quiz_score_report is in another package that returns REFCURSOR as an OUT paramter. That query is pretty complicated and I want to see the resultset of that query.
I used the thread as a guidline: http://www.dbasupport.com/forums/sho...threadid=38317

Thanks,
Shiva.