0100C
PostgreSQLWARNINGCriticalWarningHIGH confidence
dynamic result sets returned
What this means
SQLSTATE 0100C is raised when a SQL routine (e.g., a stored procedure) returns more result sets than the caller expected or declared. It is informational and does not abort the statement.
Why it happens
- 1A procedure returns multiple cursors or result sets and the caller only declared capacity for fewer
How to reproduce
SQL/PSM procedure returning dynamic result sets.
expected output
WARNING: dynamic result sets returned
Fix
Declare the correct number of result sets in the caller
WHEN When the warning appears in application logs from stored procedure calls.
Why this works
Ensure the calling context (e.g., JDBC, libpq) processes all returned result sets from a procedure.
Sources
Official documentation ↗
Class 01 — Warning
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev