[Solved] Given this code snippet:DECLARE cur CURSOR FOR SELECT name FROM products; OPEN cur; FETCH cur; CLOSE cur; FETCH cur;What error will occur when running this code? | PostgreSQL

PostgreSQL - Advanced PL/pgSQL

Given this code snippet:

DECLARE cur CURSOR FOR SELECT name FROM products;
OPEN cur;
FETCH cur;
CLOSE cur;
FETCH cur;

What error will occur when running this code?

AERROR: cursor "cur" does not exist

BNo error, FETCH returns next row

CERROR: syntax error near FETCH

DERROR: cursor "cur" is not open

Step-by-Step Solution

Solution:

Step 1: Analyze cursor lifecycle
Cursor is declared and opened, then FETCH is called once, then cursor is closed.
Step 2: Identify error on second FETCH
After CLOSE, cursor is not open, so FETCH causes "cursor is not open" error.
Final Answer:
ERROR: cursor "cur" is not open -> Option D
Quick Check:
FETCH after CLOSE causes 'not open' error [OK]

Quick Trick: Cannot FETCH after CLOSE; cursor must be open [OK]

Common Mistakes:

Master "Advanced PL/pgSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Given this code snippet: