Can cursor variables be stored in PL/SQL?

[sandhya rani]

Hai forum members,
Can we store cursor variables in PL/SQL.According to me the answer is NO.
Because a cursor variable points a row which can't be stored in 2-Dimensional PL/SQL Table...Justify my answer........

[chandu031]

Hai forum members,
Can we store cursor variables in PL/SQL.According to me the answer is NO.
Because a cursor variable points a row which can't be stored in 2-Dimensional PL/SQL Table...Justify my answer........

Hi Sandhya,

Could you be more clear. According to my understanding a cursor variable is nothing but a cursor opened in one PLSQL routine and fetched by another routine. So are you suggesting a cursor result set cannot be stored in a PL/SQL table? I would appreciate it if you were to give an example to state your point more clearly.

Cheers!