HomePrivacy PolicyFeedbackLink to usSite Map

Oracle/PLSQL: ORA-01001 Error

Error:

 ORA-01001: invalid cursor

Cause:

 You tried to reference a cursor that does not yet exist. This may have happened because:
  1. You've executed a FETCH cursor before OPENing the cursor.
  2. You've executed a CLOSE cursor before OPENing the cursor.
  3. You've executed a FETCH cursor after CLOSING the cursor.

Action:

 The options to resolve this Oracle error are:
  1. Make sure you haven't CLOSEd the cursor and are still referencing it in your code.
  2. Make sure you've OPENed the cursor before calling a FETCH cursor or CLOSE cursor.
  3. If everything else is fine, you may need to increase the AREASIZE and MAXOPENCURSORS options.