Is there a limit on the size of a PL/SQL block?

Question

Hello

Is there a limit on the size of a PL/SQL block?

Please give me your feedback......

Answer 1

Currently, the maximum parsed/compiled size of a PL/SQL block is 64K and the maximum code size is 100K. You can run the following select statement to query the size of an existing package or procedure.
SQL> select * from dba_object_size where name = 'procedure_name'