|Table of Contents
6.3.1 or above
Unable to fetch.
This error occurs when the database is running in non-autocommit mode and the COMMIT statement is executed before a fetch operation has completed.
If the fetch operation continues (using the open cursor) after the COMMIT statement has been executed, the cursor becomes invalid and the fetch operation fails.
1. Run the database in autocommit mode.
2. When running in non-autocommit mode, complete the fetch operation and then execute CLOSE CURSOR. Afterwards, execute COMMIT.
3. Use two or more multiple connections and execute the FETCH and COMMIT statements separately.