Working on oracle DB and used a sysrefcursor. I need to fetch one value from cursor. But whenever we use
FETCH p_cursor INTO variable;
it completely clears out all the data from cursor. I need this cursor in the procedure. Could any one please tell me the procedure of fetching the data from cursor without clearing it.