[Solved] What is wrong with this cursor declaration?DECLARE mycursor CURSOR FOR SELECT id FROM orders WHERE status = 'shipped'; OPEN mycursor; FETCH NEXT FROM mycursor; | PostgreSQL

PostgreSQL - Advanced PL/pgSQL

What is wrong with this cursor declaration?

DECLARE mycursor CURSOR FOR SELECT id FROM orders WHERE status = 'shipped';
OPEN mycursor;
FETCH NEXT FROM mycursor;

ACursor must be declared inside a transaction block

BCursor name must not contain uppercase letters

CCursor declaration is correct; no error

DCursor declaration missing IS keyword

Step-by-Step Solution

Solution:

Step 1: Recall cursor transaction rules
In PostgreSQL, cursors must be declared inside a transaction block.
Step 2: Analyze code context
Code snippet does not show BEGIN; without transaction, cursor usage fails.
Final Answer:
Cursor must be declared inside a transaction block -> Option A
Quick Check:
Cursors require transaction block [OK]

Quick Trick: Declare cursors inside BEGIN...COMMIT block [OK]

Common Mistakes:

Master "Advanced PL/pgSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What is wrong with this cursor declaration?