ERR-266300 Request of fetching data to an unprepared SQL statement#
Version#
6.3.1 or later
Explanation#
Unable to fetch.
Cause#
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.
Action#
-
Run the database in autocommit mode.
-
When running in non-autocommit mode, complete the fetch operation and then execute CLOSE CURSOR. Afterwards, execute COMMIT.
-
Use two or more multiple connections and execute the FETCH and COMMIT statements separately.
Reference#
N/A