Error ORA-01002: Fetch out of Sequence in Oracle

ORA-01002: fetch out of sequence:

Cause: This error means that a fetch has been attempted from a cursor which is no longer valid. Note that a PL/SQL cursor loop implicitly does fetches, and thus may also cause this error. There are a number of possible causes for this error, including: 

• Fetching from a cursor after the last row has been retrieved and the ORA-1403 error returned. 
• If the cursor has been opened with the FOR UPDATE clause, fetching after a COMMIT has been issued will return the error. 
• Rebinding any placeholders in the SQL statement, then issuing a fetch before re executing the statement. 

Action:

• Do not issue a fetch statement after the last row has been retrieved - there are no more rows to fetch.
• Do not issue a COMMIT inside a fetch loop for a cursor that has been opened FOR UPDATE.
• Re execute the statement after rebinding, then attempt to fetch again.