In this blog post, let’s learn about the error message “265 Load or insert cursors must be run within a transaction.” in Hydra and the description of the error.
Error Message
265 Load or insert cursors must be run within a transaction.
Error Details
This statement, probably a FETCH statement that names a cursor declared FOR UPDATE, failed because the row it should have fetched could not be locked. Check the accompanying ISAM error code (usually -107, -113,-134, -143, -144, or -154) for more information. Probably another program is using the row (-107) or table (-113). You can use SET LOCKMODE TO WAIT to eliminate these errors, but detection of deadlock (-143 or -154) and lock table full (-134) can still occur.
Leave a Reply