In this blog post, let’s learn about the error message “364 Column column-name not declared for UPDATE OF.” in Hydra and the description of the error.
Error Message
364 Column column-name not declared for UPDATE OF.
Error Details
This UPDATE…WHERE CURRENT OF cursor-name statement refers to at least one column that does not appear in the FOR UPDATE OF clause of the DECLARE statement that declared the cursor. Since specific columns were listed in the cursor declaration, the database server will not allow others to be updated. Review the declaration and the uses of this cursor. Perhaps the noted column, and others, should be added to the declaration, or perhaps the OF clause should be dropped, allowing the cursor to update any column in the table.