Question: what is the difference between cursor and ref cursor in oracle?
Answer: The ref cursor can be anything. ... a plsql "cursor cursor" cannot be returned to a client. Another difference is a cursor can be global -- a ref cursor cannot (you cannot define them OUTSIDE of a procedure / function) Another difference is a ref cursor can be passed from subroutine to subroutine -- a cursor cannot be.