Ref cursor variable declaration

[ddrozdov]

rshivagami, you are confused. What are you trying to do anyway?
Is this homework?

You need to open your refcursor for some kind of a select statement before trying to fetch.
Did reporting.quiz_score_report open the refcursor?
Create a function in the package like Jeff advised. If you do it in the package initialization section then how will you call this code? The package initialization runs once only and you have to call some kind of packaged object to get it to run.