Skip to content

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#

  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.

Reference#

N/A