In PL/SQL what is a difference between a cursor and a reference cursor?

[arumurali]

As of my my knowledge, Cursor is used to process SQL statements in private area and we can use it further. A Ref cursor is defining a cursor at the spot where it is needed.Correct me if i am wrong..

[r035198x]

Sort of yes but formally they cannot be global which normal cursors can be. Basically ref cursors are dynamic while normal cursors are static. You can read a more detailed analysis of refcursors here: https://forums.oracle.com/forums/thr...hreadID=886365

[arumurali]

Thanks for your reply r035198x..The forum was quite useful..!!