02001
PostgreSQLWARNINGNo DataHIGH confidence
no additional dynamic result sets returned
What this means
SQLSTATE 02001 indicates that a procedure or routine returned fewer dynamic result sets than the caller anticipated. The call completed but additional cursors or result sets were not produced.
Why it happens
- 1A SQL procedure returned fewer result sets than the calling context expected
How to reproduce
Caller requests more result sets than the procedure produces.
expected output
WARNING: no additional dynamic result sets returned
Fix
Align caller expectations with the procedure definition
WHEN When this warning surfaces from a stored procedure call.
Why this works
Review the procedure to confirm how many result sets it returns and update the calling code accordingly.
Sources
Official documentation ↗
Class 02 — No Data
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev