In this blog post, let’s learn about the error message “327 Cannot unlock table table-name within a transaction.” in Hydra and the description of the error.
Error Message
327 Cannot unlock table table-name within a transaction.
Error Details
The statement UNLOCK TABLE is not allowed within a transaction, that is, following the execution of BEGIN WORK. You can still use LOCK TABLE when you use transactions, but the table will be unlocked automatically when the transaction ends. All locks are released at the end of a transaction. In an ANSI-compliant database, BEGIN WORK is not used, a transaction is always in effect, and the UNLOCK TABLE statement is never used.