ERR-266300

Request of fetching data to an unprepared SQL statement

Version

6.3.1 or above

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

Copyright ⓒ 2000~2016 Altibase Corporation. All Rights Reserved.

These documents are for informational purposes only. These information contained herein is not warranted to be error-free and is subject to change without notice. Decisions pertaining to Altibase’s product characteristics, features and development roadmap are at the sole discretion of Altibase. Altibase may own related patents, trademarks, copyright or other intellectual property rights of products and/or features discussed in this document.