Oracle CURSOR with parameter
Oracle CURSOR with parameter.Execution of a cursor puts the results of the query into a set of rows called the result set, which can be fetched sequentially or non sequentially.
Oracle CURSOR with parameter.Execution of a cursor puts the results of the query into a set of rows called the result set, which can be fetched sequentially or non sequentially.
ORA-01001: invalid cursor error occurs when you tried to reference a cursor that does not yet exist.
A few scenarios given below.
A cursor is a name for private SQL area.It is in private SQL area the parsed statement and other information for processing the statement are kept.
ORA-01000: maximum open cursors exceeded.Each user session can open multiple cursors up to the limit set by the initialization parameter OPEN_CURSORS.
A cursor is a name for private SQL area.It is in private SQL area where the parsed statement and other information for processing the statement are kept.