Question: what is the difference between ref cursor and normal pl/sql cursors?
Answer: A ref cursor is a pointer to a result set. This is normally used to open a query on the database server, then leave it up to the client to fetch the result it needs. A ref cursor is also a cursor, though normally ther term cursor is used when discussing static SQL. Static cursor is associated with single SQL query.