Code Inspection: Illegal cursor state
Reports illegal cursor states inside SQL routines.
A routine has CLOSE or FETCH statements but a cursor might be closed.
A routine has the OPEN statement but a cursor might be opened.
Example (Microsoft SQL Server):
According to CLOSE (Transact-SQL) at docs.microsoft.com, CLOSE must be issued on an open cursor, and CLOSE is not allowed on cursors that have only been declared or are already closed. So, we need to open the cursor to fix the warning.
Suppress an inspection in the editor
Place the caret at the highlighted line and press Alt+Enter or click .
Click the arrow next to the inspection you want to suppress and select the necessary suppress action.