Firebird Documentation IndexFirebird 3.0.2 Release NotesProcedural SQL (PSQL) → PSQL Body Size Limit Raised
Firebird Home Firebird Home Prev: EXECUTE BLOCK Run-time ErrorsFirebird Documentation IndexUp: Procedural SQL (PSQL)Next: Monitoring & Command-line Utilities

PSQL Body Size Limit Raised

If and only if the new API is being used, the size of the body of a stored procedure or a trigger can exceed the traditional limit of 32 KB. Currently, as a security measure, a hard-coded limit of 10MB is imposed, although the theoretical limit is 4GB. The traditional size of all input or output parameters no longer limited to the traditional size of (64KB minus overhead), either.

For details, see Some SQL Size Limits Removed Using New API in the API chapter.

Prev: EXECUTE BLOCK Run-time ErrorsFirebird Documentation IndexUp: Procedural SQL (PSQL)Next: Monitoring & Command-line Utilities
Firebird Documentation IndexFirebird 3.0.2 Release NotesProcedural SQL (PSQL) → PSQL Body Size Limit Raised