Multiple choice technology databases

What is the limit on the size of a PL/SQL block?

  1. 32K

  2. 64K

  3. 100K

  4. None of the Above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

PL/SQL blocks have a size limit of 64K. This is a database-specific constraint on the maximum size of code that can be contained in a single PL/SQL block. The limit applies to the compiled code size, not the source text length. This constraint is important for developers writing complex stored procedures or large anonymous blocks.

Keep practicing — related questions